Search Postgresql Archives

Re: order of checking the unique constraints

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Sahagian, David
Sent: Dienstag, 28. August 2012 15:46
To: pgsql-general@xxxxxxxxxxxxxx
Subject: 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-

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux