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