Constraint enforcement - Mailing list pgsql-general

From Demian Lessa
Subject Constraint enforcement
Date
Msg-id 45D48718.4040406@lessa.org
Whole thread Raw
Responses Re: Constraint enforcement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Is there any documentation other than the soruce code on how postgres
performs the appropriate (PK, FK, CHECK, UNIQUE) constraint enforcement
on DELETEs, UPDATEs, and INSERTs?

What I'm trying to figure out is how postgre identifies the *exact* set
of constraints to enforce for each of the different commands above, and
the order in which these are performed (since some checks are way more
expensive than others).

Thank you,

Demian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFF1IcYWs7G5iIp9akRAgM4AKChLgEMZRJC36hpEPDtPBPjrVfFJwCfSe43
B1KNLqOsn5qQnbXPnup2n7A=
=kABQ
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Recover anything from dropped database?
Next
From: Emi Lu
Date:
Subject: postgresql 8.2 Installation error at "gmake"