Re: operator exclusion constraints
Jeff Davis <pgsql@j-davis.com>
From: Jeff Davis <pgsql@j-davis.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2009-11-06T19:22:31Z
Lists: 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