Robert Haas <robertmh...@gmail.com> writes: > On Thu, Nov 14, 2013 at 12:28 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >>> 2) Allow foreign tables to have CHECK constraints >>> Like NOT NULL, I think we don't need to enforce the check duroing >>> INSERT/UPDATE against foreign table.
>> Really? > I think it's been previously proposed that we have some version of a > CHECK constraint that effectively acts as an assertion for query > optimization purposes, but isn't actually enforced by the system. I > can see that being useful in a variety of situations, including this > one. Yeah, I think it would be much smarter to provide a different syntax to explicitly represent the notion that we're only assuming the condition is true, and not trying to enforce it. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers