Re: visibility rules for AFTER UPDATE Constraint Triggers Function

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: visibility rules for AFTER UPDATE Constraint Triggers Function
Дата
Msg-id 108138.94307.qm@web31808.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: visibility rules for AFTER UPDATE Constraint Triggers Function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
--- On Wed, 1/2/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> [ pokes at it... ]  The reason is that you defined both the trigger and
> the testing function as STABLE, which means that they see a snapshot of
> the database as of the start of the calling SQL command.  In the first
> case that's the UPDATE, in the second it's the COMMIT.

Thanks for the help Tom.  This information is good to know.

Regards,
Richard Broersma Jr.

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: [SQL] PG is in different timezone than the OS
Следующее
От: Martin Langhoff
Дата:
Сообщение: PITR - filter by database?