Is "query" a reserved word in 8.3 plpgsql?

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

Responses

Browse pgsql-general by date

  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...

Browse pgsql-hackers by date

  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