Re: upgrading from V8.3.4 to V9.2.4

On Wed, Apr 3, 2013 at 10:02 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> On 04/03/2013 10:14 AM, Paul Tilles wrote:
>>
>> We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in
>> the near future.
>>
>> Can anyone give me a short list of "gotchas" concerning problems we
>> might step into?
>>
>> We have a number of functions written in PL/pgSQL. Will they work in
>> 9.2.4 without modification?
>
>
> Starting at 8.3.x means you have cleared the type casting changes. The issue
> I remember moving functions from 8.3 --> had to do with the changes in the
> string escaping, see here for a start:
>
> http://www.postgresql.org/docs/9.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS-ESCAPE
>
>

Yeah, there were also some subtle breakage around keywords used as
variable naming when plpgsql was port to use the core lexer. Ideally
you'll have some kind of test suite / regression you can run to verify
all of this; if not you maybe you can set up some replication between
old/new servers (we use mimeo for that when sever versions are this
far apart) and point your app to both and see what happens.

Robert Treat
conjecture: xzilla.net
consulting: omniti.com