Re: Skip trigger?
От | hamann.w@t-online.de |
---|---|
Тема | Re: Skip trigger? |
Дата | |
Msg-id | wolfgang-1160501141810.A021479@linux-f7v9 обсуждение исходный текст |
Ответ на | Re: Skip trigger? (Manuel Gómez <targen@gmail.com>) |
Список | pgsql-general |
>> On Sat, Apr 30, 2016 at 1:38 AM, <wolfgang@alle-noten.de> wrote: >> > I have a table with a row update trigger that is quite slow. >> > The trigger finction basically sets some bits in a "changed" column >> > depending on which values really changed. >> > For some bulk updates it can be determined in advance that the >> > trigger function will not have any effect. >> > Is there any way to run an update query and specify that it should not >> > activate the trigger. >> > I know that I can disable the trigger and reenable it later; >> > however other concurrent updates mights need it >> >> Indeed the main issue is how you want to handle concurrency. ALTER >> TABLE statements to disable triggers works and is transactional, but >> locks the table, which may be undesired. Here are some useful >> pointers: http://blog.endpoint.com/2015/07/selectively-firing-postgres-triggers.html >> Hi Manuel, many thanks ... this seems to be just what I was looking for. I will give it a try tomorrow Regards Wolfgang Hamann
В списке pgsql-general по дате отправления: