Postgres Pro
Downloads
Home   >   mailing lists

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

From Sahagian, David
Subject order of checking the unique constraints
Date
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D8E718E43@MX22A.corp.emc.com
Whole thread Raw
Responses Re: order of checking the unique constraints
List pgsql-general
Tree view
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: Merlin Moncure
Date:
Subject: Re: Overlapping time ranges constraints in 8.4
Next
From: Chris Travers
Date:
Subject: Re: 9.2 and index only scans