Re: order of checking the unique constraints

Поиск
Список
Период
Сортировка
От Marc Mamin
Тема Re: order of checking the unique constraints
Дата
Msg-id C4DAC901169B624F933534A26ED7DF310861B676@JENMAIL01.ad.intershop.net
обсуждение исходный текст
Ответ на order of checking the unique constraints  ("Sahagian, David" <david.sahagian@emc.com>)
Ответы Re: order of checking the unique constraints
Список pgsql-general
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: 9.2 and index only scans
Следующее
От: José Pedro Santos
Дата:
Сообщение: Re: FGS - Postgresql server install