Stupid question about triggers
От | Mauri Sahlberg |
---|---|
Тема | Stupid question about triggers |
Дата | |
Msg-id | 43218C15.1070704@claymountain.com обсуждение исходный текст |
Ответы |
Re: Stupid question about triggers
|
Список | pgsql-admin |
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 по дате отправления: