Postgres Pro
Downloads
Home   >   mailing lists

Re: Disabling triggers in a transaction - Mailing list pgsql-general

From Tom Lane
Subject Re: Disabling triggers in a transaction
Date
Msg-id 24920.1109622144@sss.pgh.pa.us
Whole thread Raw
In response to Disabling triggers in a transaction  (Jay Guerette <jayguerette@gmail.com>)
Responses Re: Disabling triggers in a transaction  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
Tree view 
Jay Guerette <jayguerette@gmail.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

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: PostgreSQL 8 compiling for Windows
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Fast major-version upgrade (was: postgresql 8.0 advantages)