Constraint ordering

Поиск
Список
Период
Сортировка
От Perry Smith
Тема Constraint ordering
Дата
Msg-id 77C5CA14-9BB6-42A8-B700-4CDE2D69066E@easesoftware.com
обсуждение исходный текст
Ответы Re: Constraint ordering  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Constraint ordering  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
I think (hope) I’ve made a bad assumption.  I have my DB with one table with two constraint on new entries.  The
“first”is for the parent and basename be unique.  The “second” is that the devno and inode are unique if it is a
directory.

When I was doing my early testing, the parent+basename constraint would fire first if it needed to.  Now that I’m doing
alonger test run, the second constraint is firing at a time that I wasn’t expecting.  I’m debugging but it takes time
tohit this again. 

My assumption was if the error reported back that the “second" constraint failed that the “first” constraint passed.
ButI bet that isn’t a valid assumption at all. 

All that to ask: is there a predictable ordering of constraints?

Thank you,
Perry


Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: FOR integer loop bug?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Constraint ordering