Re: Disabling triggers in a transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jay Guerette <jayguerette(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Disabling triggers in a transaction
Date: 2005-02-28 20:22:24
Message-ID: 24920.1109622144@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jay Guerette <jayguerette(at)gmail(dot)com> writes:
> If I disable INSERT and UPDATE triggers inside a transaction; by
> setting and resetting reltriggers in pg_class; am I correct in
> thinking that this will disable triggers globally for that table for
> the duration of that transaction?

Not if you never commit the pg_class row in that state.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-02-28 20:27:46 Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages)
Previous Message John DeSoi 2005-02-28 20:17:29 Re: PostgreSQL 8 compiling for Windows