agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: gmb <gmbouwer@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Disable Trigger for session only
Date: Mon, 29 Jun 2015 06:06:29 -0700
Message-ID: <559142D5.2080608@aklaver.com> (raw)
In-Reply-To: <1435563798887-5855658.post@n5.nabble.com>
References: <1435563798887-5855658.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
On 06/29/2015 12:43 AM, gmb wrote:
> Hi
>
> I' pretty sure I know the answer, but trying my luck.
>
> I'm in a position where the most logical/effective way of doing an update
> (data fix) is this:
> ALTER TABLE temp DISABLE TRIGGER trigname;
> UPDATE temp ..... DO SOME STUFF....
> ALTER TABLE temp DISABLE TRIGGER trigname;
>
> Some notes:
> It cannot be guaranteed that the above happens as a single transaction.
> It is possible that this occurs at the same time as other session posting
> inserts/updates to table TEMP.
It can if wrapped in BEGIN/COMMIT or is there reason that is not being done?
>
> I'm seeing data which suggests that trigger trigname did not occur when in
> fact it should have ( i.e. the above update procedure is not relevant ).
> Does this make sense taking into account that multiple sessions posts to the
> table at once ?
Not without knowing what the trigger procedure does?
>
> I'm aware that session_replication_role can be used as alternative to
> disable triggers, and have been using it in other scenarios. But in this
> case i'd like to choose which trigger to disable (I want other triggers on
> table temp to still occur).
>
> Is there any other alternatives to this ?
>
> Will appreciate any input
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (8+ messages) latest in thread
Message-ID: <559142D5.2080608@aklaver.com>
Permalink: ../559142D5.2080608@aklaver.com/
Also on: postgresql.org/message-id/559142D5.2080608@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, gmbouwer@gmail.com
Subject: Re: Disable Trigger for session only
In-Reply-To: <559142D5.2080608@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox