Hello,
I had a similar question some time ago, with an answer by Tom lane: http://archives.postgresql.org/pgsql-general/2012-03/msg00023.php best regards, Marc Mamin From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sahagian, David Sent: Dienstag, 28. August 2012 15:46 To: pgsql-general@postgresql.org Subject: [GENERAL] order of checking the unique constraints Using 9.1 Can somebody tell me the order in which the Unique Constraints of a table are checked, like when an INSERT is done ? It seems the the Primary is checked first, but what about the regular UCs ? Thanks, -dvs-