>> Can somebody tell me the order in which the Unique Constraints of a table >> are checked, like when an INSERT is done ? > > I had a similar question some time ago, with an answer by Tom lane: > http://archives.postgresql.org/pgsql-general/2012-03/msg00023.php You might also find interesting that this behavior can be controlled by specifying DEFERRABLE/IMEDIATE properties on your UCs and by using SET CONSTRAINTS dirrective. http://www.postgresql.org/docs/9.1/interactive/sql-set-constraints.html -- Sergey Konoplev a database and software architect http://www.linkedin.com/in/grayhemp Jabber: gray.ru@xxxxxxxxx Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
