Re: Trigger / rule question

Поиск
Список
Период
Сортировка
От Joost Kraaijeveld
Тема Re: Trigger / rule question
Дата
Msg-id 1132500990.17919.34.camel@Panoramix
обсуждение исходный текст
Ответ на Re: Trigger / rule question  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-sql
Hi Peter,

On Sun, 2005-11-20 at 12:08 +0100, Peter Eisentraut wrote:
> Joost Kraaijeveld wrote:
> > 1. Does an insert, update or delete statement return before or after
> > an "After" trigger (is such a trigger or rule synchronous or
> > a-synchronous?
> 
> Synchronous
> 
> > 2. Is there a concept of a rule or trigger that fails? 
> > If so, if a trigger or rule fails, does the insert, update or delete
> > statement (transaction)  fail?
> 
> Yes
OK, thanks for the answer.

-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl 




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

Предыдущее
От: Andy Ballingall
Дата:
Сообщение: Re: Is it possible to redirect an update/insert/delete to a different table?
Следующее
От: Andy Ballingall
Дата:
Сообщение: Re: Is it possible to redirect an update/insert/delete to a different table?