Postgres Pro
Downloads
Home   >   mailing lists

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

From Marc Mamin
Subject Re: order of checking the unique constraints
Date
Msg-id C4DAC901169B624F933534A26ED7DF310861B676@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to order of checking the unique constraints  ("Sahagian, David" <david.sahagian@emc.com>)
Responses Re: order of checking the unique constraints  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
Tree view

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-owner@postgresql.org [mailto:pgsql-general-owner@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-

 

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: 9.2 and index only scans
Next
From: José Pedro Santos
Date:
Subject: Re: FGS - Postgresql server install