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/

Reply via email to