How to lock or disable a trigger

Поиск
Список
Период
Сортировка
От sid tow
Тема How to lock or disable a trigger
Дата
Msg-id 20050125064850.14301.qmail@web42108.mail.yahoo.com
обсуждение исходный текст
Ответы Re: How to lock or disable a trigger  (Jeff Davis <jdavis-pgsql@empires.org>)
Список pgsql-general
Hi

     I am new to SQL. Is there a way to lock or
disable  temporarily a trigger? Since under load
conditions while updating the database if the triggers
are down then it might help updating the db faster. I
am using postgre 7.2 and have to update only with
INSERT commands. since with copy command i cannot
update columns of my choice, meaning all the columns
of a table has to be loaded with a copy command.

     Can any one help me with this and clarify. These
triggers are RI_ConstraintTriggers.

Regards
sid

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Search for restricting foreign keys
Следующее
От: "Danny Lu"
Дата:
Сообщение: How do I connect to Postgresql on Windows 98?