Re: operator exclusion constraints - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: operator exclusion constraints
Date
Msg-id 1257535351.28470.227.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to Re: operator exclusion constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: operator exclusion constraints
List pgsql-hackers
On Fri, 2009-11-06 at 14:00 -0500, Tom Lane wrote:
> The main advantage of the CHECK WITH syntax in my eyes was that it
> avoided the need to create a new reserved word.

It still needs the EXCLUSION keyword, though, and where does that fit
in? If I include it as unreserved, I get shift/reduce conflicts. If I
include it as a type_func_name keyword, it works.

CHECK, FOREIGN, PRIMARY, and UNIQUE are all reserved as well, which
makes sense because it looks like they conflict directly with column
names in the table definition.

Do you see a way to avoid that problem?

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: operator exclusion constraints
Next
From: Tom Lane
Date:
Subject: WHERE CURRENT OF $n still needed?