Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added
Дата
Msg-id 15074.1076427520@sss.pgh.pa.us
обсуждение исходный текст
Ответ на abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added  (Daniel Struck <struck.d@retrovirology.lu>)
Ответы Re: abnormal behaviour of a CHECK CONSTRAINT with a regular  (Daniel Struck <struck.d@retrovirology.lu>)
Список pgsql-bugs
Дерево обсуждения 
Daniel Struck <struck.d@retrovirology.lu> writes:
> I think I have found a bug in postgresql:

I don't see any bug here; it's just that CHECK constraints are applied
after any BEFORE triggers are run.  Since the triggers could change the
data to be inserted, the reverse order would be insecure.

            regards, tom lane

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

Предыдущее
От: John Siracusa
Дата:
Сообщение: Re: Expected regression test difference on Mac OSX...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added