From: PegoraroF10 <marcos@f10.com.br>
To: pgsql-docs@postgresql.org
Subject: UPDATE OF on REPLICA TRIGGERS
Date: Fri, 4 Jan 2019 05:20:48 -0700 (MST)
Message-ID: <1546604448278-0.post@n3.nabble.com> (raw)
We tried a lot, maybe for some days, to have some triggers working properly
on a replica server. So we read a discussion that is not possible to have
UPDATE OF in a trigger which works only on REPLICA. Our tests was production
using version 10 and replica using version 11.
I thing it would be helpful if the docs had this explained. Or an exception
would occur when we try to create a REPLICA TRIGGER with UPDATE OF.
Document it with something like ... replace your "UPDATE OF col1, col2" when
you create your trigger which works only on replica for "new.col1 is
distinct of old.col1" inside your trigger function.
CREATE OR REPLACE FUNCTION CalculateSomethingOnReplica() RETURNS TRIGGER AS
$$
BEGIN
IF tg_op = 'update' THEN
IF new.col1 IS NOT DISTINCT FROM old.col1 THEN
--DoTheCalc
END IF;
END IF;
RETURN NULL;
END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER CalculateSomethingOnReplica AFTER UPDATE ON MyTable FOR EACH
ROW EXECUTE PROCEDURE CalculateSomethingOnReplica();
ALTER TABLE MyTable ENABLE REPLICA TRIGGER CalculateSomethingOnReplica;
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-docs-f2165602.html
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-docs@postgresql.org
Cc: marcos@f10.com.br
Subject: Re: UPDATE OF on REPLICA TRIGGERS
In-Reply-To: <1546604448278-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox