disabling triggers?

Поиск
Список
Период
Сортировка
От Bob Parkinson
Тема disabling triggers?
Дата
Msg-id Pine.OSF.4.21.0007181603140.15419-100000@omni.ac.uk
обсуждение исходный текст
Ответы Re: disabling triggers?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I've noticed the recent query about dropping a function with a trigger.

I've got a trigger/function pair that I need to disable while I do a
manual update. Is it safe to drop the trigger, then re-create it on its
own, or should I do the trigger/function pair.

Is there a better method of temporarily disabling a trigger?

Cheers,

Bob

Bob Parkinson
rwp@biome.ac.uk
------------------------------------------------------------------
Technical Manager:         Biome             http://biome.ac.uk/

Greenfield Medical Library,
Queens Medical Centre,
Nottingham.                          0115 9249924 x 42059
------------------------------------------------------------------
                        We are stardust


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

Предыдущее
От: "Alex Bolenok"
Дата:
Сообщение: Re: Migrating from MS SQL server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ordering of 'where' sub clauses