From: | "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com> |
---|---|
To: | Postgresql-General mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Is "query" a reserved word in 8.3 plpgsql? |
Date: | 2007-11-09 22:06:33 |
Message-ID: | 4734D9E9.2070101@blackducksoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi,
I saw the item in the release notes about the new "return query" syntax in pl/pgsql,
but I didn't see any note about "query" being reserved now. Perhaps an explicit
mention should be added?
I loaded a dump from 8.2.4 into 8.3b2 without error. However, every function that
uses "query" as a variable name now fails with a syntax error when it is executed:
ERROR: syntax error at or near "query" at character 151
My workaround will be to extract the functions from the dump, edit them to rename
the variable, and load them into the new db.
-- todd
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-11-09 22:17:11 | Re: "Resurrected" data files - problem? |
Previous Message | Dann Corbit | 2007-11-09 21:47:43 | Re: Importance of CPU floating point performance... |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-11-09 22:07:24 | Re: [HACKERS] install-strip causes dyld errors on OS X |
Previous Message | Andrew Dunstan | 2007-11-09 21:28:39 | dump order for index defs |