Re: How to lock or disable a trigger

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

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?
>
> http://archives.postgresql.org