Search Postgresql Archives
order of checking the unique constraints
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: "
pgsql-general@xxxxxxxxxxxxxx
" <
pgsql-general@xxxxxxxxxxxxxx
>
Subject
: order of checking the unique constraints
From
: "Sahagian, David" <
david.sahagian@xxxxxxx
>
Date
: Tue, 28 Aug 2012 09:45:38 -0400
Accept-language
: en-US
Acceptlanguage
: en-US
Thread-index
: Ac2FI2gyc6uZsaotTHagvwvjdrDkQQ==
Thread-topic
: 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
]
Follow-Ups
:
Re: order of checking the unique constraints
From:
Marc Mamin
Prev by Date:
Re: Overlapping time ranges constraints in 8.4
Next by Date:
Re: 9.2 and index only scans
Previous by thread:
FGS - Postgresql server install
Next by thread:
Re: order of checking the unique constraints
Index(es):
Date
Thread
[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]
