Re: Client-requested cast mode to emulate Pg8.2 on v8.3

From: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Martin Langhoff" <martin(at)catalyst(dot)net(dot)nz>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org, moodledev(at)catalyst(dot)net(dot)nz
Subject: Re: Client-requested cast mode to emulate Pg8.2 on v8.3
Date: 2008-03-21 16:05:52
Message-ID: 92d3a4950803210905n393fca5fj47b5cf2d9e00b1ea@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > - Is there a way to turn it back to the old behaviour with a
> > warning going to the logs?
>
>
> No.
>
>
> > - Is there a way to get v8.2.x to warn on the dubious casts
> > so we can tighten the application side while on v8.2?
>
>
> Seems to me the easiest way would be to try it out on an 8.3
> installation and exercise each query once. There may be a better way
> but I don't know it...

Hi,
This seems like it is one of the most frustrating (for me) decisions
that has ever been made by the postgres developers...
My situation is the following :
I inherited an application based on a dead project (byline, and don't
even mention aplaws, it's about as alive a zombie from Resident
Evil... it moves, but it ain't alive!) and we currently use postgres
8.1. The performance sucks, and there are several things in 8.3 that
are very interesting, notably synchronous_commit, plus all the
perfermance goodies since 8.1. But it is COMPLETELY out of the
question to redo the db abstraction layer, and without these implicit
casts that is what will be needed. Is there REALLY no way to reenable
it?
I fully realise and respect the logic in doing this but not having a
fallback (even if it means recompiling from source) is painful!
Am I really stuck with pre-8.3?
Cheers
Anton

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edward Blake 2008-03-21 16:06:47 MySQL to Postgres question
Previous Message Pavan Deolasee 2008-03-21 15:57:28 Re: Table size