Is "query" a reserved word in 8.3 plpgsql?

Поиск
Список
Период
Сортировка
От Todd A. Cook
Тема Is "query" a reserved word in 8.3 plpgsql?
Дата
Msg-id 4734D9E9.2070101@blackducksoftware.com
обсуждение исходный текст
Ответы Re: Is "query" a reserved word in 8.3 plpgsql?
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: Importance of CPU floating point performance...
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: "Resurrected" data files - problem?