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.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
