BDR - triggers on receiving node?

From: Peter Mogensen <apm(at)one(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: BDR - triggers on receiving node?
Date: 2015-03-25 11:15:04
Message-ID: 551298B8.1010902@one.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Traditionally it hadn't made much sense to fire a trigger on a receiving
replica node (slave) - for many reasons, including it being read-only.

But with BDRs multi parter, partial replication and the possibility that
some tables are either actually or logically local to a single node,
there's scenarios where this makes sense.

Is it possible?

Say ... I have a table in a BDR replicated database with an "ON UPDATE"
trigger. - and that trigger wants to locally find out the local
txid_snapshot_xmin() when a change was applied to the local node.
Not the upstream txid of the transaction which actually made the change
originally (which only makes sense on that node) - but on the local node
receiving the change via BDR LLSR.

Can that be done?

/Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2015-03-25 11:32:01 Re: BDR - triggers on receiving node?
Previous Message Rebecca Clarke 2015-03-25 10:50:36 Could not read block of temporary files