Re: Skip trigger?
От
hamann.w@t-online.de
Тема
Re: Skip trigger?
Дата
Msg-id
wolfgang-1160501141810.A021479@linux-f7v9
Ответ на
Re: Skip trigger? (Manuel Gómez)
Список
Дерево обсуждения
Skip trigger? wolfgang@alle-noten.de
Re: Skip trigger? Stephen Cook <sclists@gmail.com>
Re: Skip trigger? hamann.w@t-online.de
Re: Skip trigger? Peter Devoy <peter@3xe.co.uk>
Re: Skip trigger? Manuel Gómez <targen@gmail.com>
Re: Skip trigger? hamann.w@t-online.de
>> On Sat, Apr 30, 2016 at 1:38 AM, 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 по дате отправления
