Disable triggers per transaction 8.2.3

Поиск
Список
Период
Сортировка
От Henrik
Тема Disable triggers per transaction 8.2.3
Дата
Msg-id 39A7EAF5-0326-4ADC-8CC2-9589A05786AC@mac.se
обсуждение исходный текст
Ответы Re: Disable triggers per transaction 8.2.3  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-general
Hello list,

I wonder if it is possible to disable triggers for a single transaction.
I know I can disable triggers per table but then I need to disable
all triggers in all recursive tables before doing by query.

Can I do:
BEGIN TRANSACTION;
DISABLE TRIGGERS;
DELETE FROM tbl_foo WHERE ID > 5;
ENABLE TRIGGERS;
COMMIT;

Or do I have to do:
BEGIN TRANSACTION;
ALTER TABLE tbl_foo DISABLE TRIGGERS ALL;
ALTER TABLE tbl_foo_bar DISABLE TRIGGERS ALL;

DELETE FROM tbl_foo WHERE ID > 5;

ALTER TABLE tbl_foo ENABLE TRIGGERS ALL;
ALTER TABLE tbl_foo_bar ENABLE TRIGGERS ALL;

COMMIT;

Or is it even possible? I only want my triggers to be disabled for
the transaction and not the global database.

Thanks,
Henke


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

Предыдущее
От: "Ian Barber"
Дата:
Сообщение: Re: disjoint union types
Следующее
От: Sam Mason
Дата:
Сообщение: Re: disjoint union types