Stupid question about triggers

Поиск
Список
Период
Сортировка
Искать
От
Mauri Sahlberg
Тема
Stupid question about triggers
Дата
Msg-id
43218C15.1070704@claymountain.com
Список
Дерево обсуждения
Stupid question about triggers Mauri Sahlberg <Mauri.Sahlberg@claymountain.com>
Re: Stupid question about triggers Robert Treat <xzilla@users.sourceforge.net>
Re: Stupid question about triggers Mauri Sahlberg <Mauri.Sahlberg@claymountain.com>
Hi,

I have found myself in a situation where I need to quickly delete rows
from a production database. Unfortunately table for the rows to be
deleted have triggers which results massive chain of update operations
on other tables. I do not wish those to happen as I'm about to delete
concerned rows from the other tables as well. (7.4.7)

Would

begin work
select reltriggers from pg_class where relname='foo' for update;
update pg_class set reltriggers=0 where relname='foo';
delete from foo where ...
update pg_class set reltriggers=original value where relname='foo';
commit

work?

Or
begin work
select reltriggers from pg_class where relname='foo';
update pg_class set reltriggers=0 where relname='foo';
delete from foo where ...
update pg_class set reltriggers=original value where relname='foo';
commit

as I'm quite sure the number of triggers for that table will not change
while I'm doing the deletion.

Thank you.

В списке pgsql-admin по дате отправления
От: Tom Lane
Дата:
От: Dilipan Sebastiampillai
Дата:
FAQ