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
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 |