Re: CREATE FOREGIN TABLE LACUNA - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CREATE FOREGIN TABLE LACUNA
Date
Msg-id 6034.1331761092@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE FOREGIN TABLE LACUNA  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: CREATE FOREGIN TABLE LACUNA  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On ons, 2012-03-14 at 17:16 -0400, Robert Haas wrote:
>> If a constraint is NOT ENFORCED, then the query planner presumably
>> won't rely on it for planning purposes 

> Why do you presume that?

What does SQL:2011 say exactly about the semantics of NOT ENFORCED?
Is an implementation allowed to fail in undefined ways if a constraint
is marked NOT ENFORCED and is not actually true?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade and statistics
Next
From: Tom Lane
Date:
Subject: Re: Faster compression, again