Re: EVENT Keyword and CREATE TABLE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EVENT Keyword and CREATE TABLE
Дата
Msg-id 9498.1348705446@sss.pgh.pa.us
обсуждение исходный текст
Ответ на EVENT Keyword and CREATE TABLE  (Brian Weaver <cmdrclueless@gmail.com>)
Ответы Re: EVENT Keyword and CREATE TABLE  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Список pgsql-hackers
Brian Weaver <cmdrclueless@gmail.com> writes:
> In some of our old tables going back several years we a column named
> 'event' as in:
>     event character varying(1000)
> I was working off trunk and the database refuses to create this table
> any longer. Is this by design or is it a regression bug?

It's a bug.  The event-trigger patch added EVENT as a new keyword, but
forgot to list it in the unreserved_keywords production, which is
necessary to make it actually act unreserved.

I've committed a fix, and manually verified there are no other such
errors at present, but this isn't the first time this has happened.
We probably need to put in some automated cross-check, or it won't
be the last time either.
        regards, tom lane



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Does the SQL standard actually define LATERAL anywhere?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Switching timeline over streaming replication