How to lock or disable a trigger
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
There was just that question posed earlier today.
I'll refer you to the archives, where Terry Lee Tucker weighed in with a
good response:
<http://archives.postgresql.org/pgsql-general/2005-01/msg01284.php>
I hope that helps,
Jeff Davis
Show quoted text
On Mon, 2005-01-24 at 22:48 -0800, sid tow wrote:
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---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?