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

From Robert Haas
Subject Re: CREATE FOREGIN TABLE LACUNA
Date
Msg-id CA+Tgmoarvpcr6Nu10mrE6f4beh4NYGdxmHDHTtgs8zSC=OWV7A@mail.gmail.com
Whole thread Raw
In response to Re: CREATE FOREGIN TABLE LACUNA  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Wed, Mar 14, 2012 at 5:21 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> 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?

Well, as Tom alludes to, I'm guessing that NOT ENFORCED is not a
license to deliver wrong answers.  But also as Tom says, what does the
spec say?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: foreign key locks, 2nd attempt
Next
From: Daniel Farina
Date:
Subject: Re: Faster compression, again