Re: Disabling Triggers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mark Borins" <mark(dot)borins(at)rigadev(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Disabling Triggers
Date: 2005-05-11 15:43:32
Message-ID: 4427.1115826212@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mark Borins" <mark(dot)borins(at)rigadev(dot)com> writes:
> Does anyone know if it is possible to run an update statement on a table and
> for only that statement disable the trigger on the table?

No, but why fire the update if not needed? Make the trigger do
something like

UPDATE foo SET boolcol = true WHERE ... AND not boolcol;

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-05-11 15:47:47 Re: JOIN on set of rows?
Previous Message Himanshu Baweja 2005-05-11 15:36:25 how to calculate checkpoint_segments