[BUGS] BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints

2010-01-03 Thread Ben Woosley
The following bug has been logged online: Bug reference: 5258 Logged by: Ben Woosley Email address: ben.woos...@gmail.com PostgreSQL version: 8.4.2 Operating system: Mac OS 10.6 Description:Unique and foreign key constraints fail on columns with reserved names, but

Re: [BUGS] BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints

2010-01-04 Thread Ben Woosley
;re taking. On Mon, Jan 4, 2010 at 5:36 AM, Peter Eisentraut wrote: > On mån, 2010-01-04 at 03:48 +, Ben Woosley wrote: > > However, unique and foreign key constraints added using the "alter > > table add > > constraint" syntax fail on the column name. At this p

Re: [BUGS] BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints

2010-01-04 Thread Ben Woosley
Thanks Tom, I hadn't tried double-quoting, which worked fine. I'm only so well acquainted with SQL and had only tried single quotes and backticks. So, there is a way, and I'm satisfied with it. "Bug" retracted - thanks! -Ben On Mon, Jan 4, 2010 at 1:30 PM, Tom La