[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Disabling triggers in a transaction
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2005-02-28 20:22:24
Message-ID: 24920.1109622144 () sss ! pgh ! pa ! us
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread]