Re: [HACKERS] EVENT Keyword and CREATE TABLE

2012-09-27 Thread Dimitri Fontaine
Tom Lane writes: > 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. Oh. Oops. Sorry about that. > I've committed a fix, and manually verified there are no oth

Re: [HACKERS] EVENT Keyword and CREATE TABLE

2012-09-26 Thread Tom Lane
Brian Weaver 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 even

[HACKERS] EVENT Keyword and CREATE TABLE

2012-09-26 Thread Brian Weaver
I think I just got bitten hard by a commit in mid July... git sha1 3855968. In some of our old tables going back several years we a column named 'event' as in: CREATE TABLE tblaudittrail ( id bigint NOT NULL, siteid integer NOT NULL, entrytype character varying(25), form character