Disabling triggers in a transaction

From: Jay Guerette <jayguerette(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Disabling triggers in a transaction
Date: 2005-02-27 22:37:16
Message-ID: 4b9601ce05022714377ad0a14f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-02-27 22:41:10 Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.
Previous Message Bruno Wolff III 2005-02-27 21:38:13 Re: hosting - asking for advice