How to lock or disable a trigger

From: sid tow <siddy_tow(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to lock or disable a trigger
Date: 2005-01-25 06:48:50
Message-ID: 20050125064850.14301.qmail@web42108.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Danny Lu 2005-01-25 07:14:27 How do I connect to Postgresql on Windows 98?
Previous Message Michael Fuhr 2005-01-25 06:18:13 Re: Search for restricting foreign keys