order of checking the unique constraints

From: "Sahagian, David" <david(dot)sahagian(at)emc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: order of checking the unique constraints
Date: 2012-08-28 13:45:38
Message-ID: F3CBFBA88397EA498B22A05FFA9EC49D8E718E43@MX22A.corp.emc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-08-28 13:55:20 Re: 9.2 and index only scans
Previous Message Merlin Moncure 2012-08-28 13:44:30 Re: Overlapping time ranges constraints in 8.4