Constraint enforcement

Поиск
Список
Период
Сортировка
От Demian Lessa
Тема Constraint enforcement
Дата
Msg-id 45D48718.4040406@lessa.org
обсуждение исходный текст
Ответы Re: Constraint enforcement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: Recover anything from dropped database?
Следующее
От: Emi Lu
Дата:
Сообщение: postgresql 8.2 Installation error at "gmake"