Postgres Pro
Downloads
Home   >   mailing lists

Re: order of checking the unique constraints - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: order of checking the unique constraints
Date
Msg-id CAL_0b1t3G_HttdsfSNGywU5rrYzsM1UcXsJpdMOaS6XjusFoLg@mail.gmail.com
Whole thread Raw
In response to Re: order of checking the unique constraints  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-general
Tree view 
>> 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@gmail.com Skype: gray-hemp Phone: +79160686204

pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Dropping a column on parent table doesn't propagate to children?
Next
From: Kent Tong
Date:
Subject: do the files in pg_xlog differ in master and slave?