Re: Removing INNER JOINs

FK constraint enforcement may be deferred, but only to the end of the DML
transaction.  Can someone provide an example where a SELECT statement that
is not in that DML transaction and that can view only committed data can see
a FK-side row that doesn't join with any PK-side row?

I don't think I understand why the volatile function scenario.  Can a
volatile function somehow circumvent FK enforcement?  If not, then why is
the volatile function scenario different than any other DML with respect to
the enforcement of FK constraints?

thank you,

    /Jim F






--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html