On Wed, Apr 3, 2013 at 10:02 PM, Adrian Klaver <adrian.kla...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
