Re: BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints
Date
Msg-id 1262601387.31658.0.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints  ("Ben Woosley" <ben.woosley@gmail.com>)
Responses Re: BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints  (Ben Woosley <ben.woosley@gmail.com>)
List pgsql-bugs
On mån, 2010-01-04 at 03:48 +0000, Ben Woosley wrote:
> However, unique and foreign key constraints added using the "alter
> table add
> constraint" syntax fail on the column name.  At this point the
> statement has
> enough information (the host table name) to properly identify the
> column
> despite the unorthodox name.  Alternatively, you could allow the .
> syntax
> qualification inside the argument to the constraint.

Example please?

pgsql-bugs by date:

Previous
From: "Toni Helenius"
Date:
Subject: BUG #5260: Postgre crashed unexpectedly
Next
From: Craig Ringer
Date:
Subject: Re: BUG #5259: the table name double