Disabling Triggers
| От | Mark Borins |
|---|---|
| Тема | Disabling Triggers |
| Дата | |
| Msg-id | 111582284102@smtp-2.vancouver.ipapp.com обсуждение исходный текст |
| Ответы |
Re: Disabling Triggers
Re: Disabling Triggers Re: Disabling Triggers Re: Disabling Triggers |
| Список | pgsql-general |
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 по дате отправления: