Re: upgrading from V8.3.4 to V9.2.4

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

>
> Thanks in advance to the Community for your help.
>
> Paul TIlles
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com