Disabling triggers in a transaction - Mailing list pgsql-general

From Jay Guerette
Subject Disabling triggers in a transaction
Date
Msg-id 4b9601ce05022714377ad0a14f@mail.gmail.com
Whole thread Raw
Responses Re: Disabling triggers in a transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Disabling triggers in a transaction  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
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? So an INSERT or UPDATE to this
table, outside of the transaction and within that precise timeframe,
would NOT fire the trigger? If so, would the 'serializable ' isolation
level be required in order to ensure this doesn't happen?

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.
Next
From: Bruno Wolff III
Date:
Subject: Re: hosting - asking for advice