Re: Disabling Triggers

Поиск
Список
Период
Сортировка
От Franco Bruno Borghesi
Тема Re: Disabling Triggers
Дата
Msg-id e13c14ec05051108236ec6c00b@mail.gmail.com
обсуждение исходный текст
Ответ на Disabling Triggers  ("Mark Borins" <mark.borins@rigadev.com>)
Ответы Re: Disabling Triggers  ("Mark Borins" <mark.borins@rigadev.com>)
Список pgsql-general
You could add a TIMESTAMP field on the three tables (lets call it last_change), and modify your triggers to update this value every time a row is updated.

Then your trigger should update the boolean fields with the boolean value of the row with the max(last_change) in the three tables, only if the row of the table the trigger is being fired for is less than this max(last_change) value.

Hope this is understandable :)

Of course you could remove the boolean value from the three tables, create another table with the boolean value, and forget about the triggers. But I'm sure you have already though that.

Hope it helps.

2005/5/11, Mark Borins <mark.borins@rigadev.com>:

I am creating a system where I have a trigger on three different tables.  There is a particular Boolean field in each of these tables that when it is set in table it should be set the same in the other two.

 

So I figured I could put a trigger on each table that when the Boolean field was updated it would go and update the other 2.

 

However, I am concerned about cascading trigger calls.

 

Does anyone know if it is possible to run an update statement on a table and for only that statement disable the trigger on the table?


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: alter table owner doesn't update acl information
Следующее
От: "Mark Borins"
Дата:
Сообщение: Re: Disabling Triggers