Is "query" a reserved word in 8.3 plpgsql?

"Todd A. Cook" <tcook@xxxxxxxxxxxxxxxxxxxxx> · Fri, 09 Nov 2007 17:06:33 -0500

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/