Peter Eisentraut <pete...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers