Running query without trigger?

Поиск
Список
Период
Сортировка
Искать
От
hamann.w@t-online.de
Тема
Running query without trigger?
Дата
Msg-id
wolfgang-1160709082023.A0119336@linux-f7v9
Список
Дерево обсуждения
Running query without trigger? hamann.w@t-online.de
Re: Running query without trigger? "Charles Clavadetscher" <clavadetscher@swisspug.org>
Re: Running query without trigger? Christian Elmerot <ce@one.com>
Re: Running query without trigger? hamann.w@t-online.de
Re: Running query without trigger? hamann.w@t-online.de
Re: Running query without trigger? Berend Tober <btober@computer.org>

Hi,

a table is associated with a trigger for normal use.
An admin (someone with ALTER privilege) can disable tthe trigger, run some bulk update,
and then re-enable it. This means, however, that  normal user activity has to be locked out.

There are two possible scenarios: the bulk update would not cause trigger activity at all,
because of the values and columns involved.
or - the bulk update is followed by another bulk transaction that  is equivalent to trigger
invocations per row.
At least in the first case, running this particular query without triggering the trigger,
but normal activity still going on, would be really great
Is there a way to achieve this?

Regards
Wolfgang Hamann



В списке pgsql-general по дате отправления
От: John R Pierce
Дата:
Сообщение: Re: Memory usage per session
От: Charles Clavadetscher
Дата:
FAQ