Re: [PATCH] Support for Array ELEMENT Foreign Keys - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] Support for Array ELEMENT Foreign Keys
Date
Msg-id 8635.1350679243@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Support for Array ELEMENT Foreign Keys  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: [PATCH] Support for Array ELEMENT Foreign Keys
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On 10/19/2012 03:55 PM, Tom Lane wrote:
>> That doesn't get us any closer to having a working column-constraint
>> syntax unfortunately, because EACH is not a reserved word either
>> so "EACH ELEMENT REFERENCES" still isn't gonna work.  I'm getting
>> more willing to give up on having a column-constraint form of this.

> "ALL" is a fully reserved keyword. Could we do something like "ALL 
> ELEMENTS"?

[ experiments... ]  bison is happy with "ALL ELEMENTS REFERENCES ..."
as a column constraint, but from the standpoint of English grammar
it's kinda sucky.  "ANY ELEMENT REFERENCES ..." would be fine but
that's not the case we're implementing now.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [BUGS] BUG #7521: Cannot disable WAL log while using pg_dump
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Support for Array ELEMENT Foreign Keys