CreateReplicationTriggers.sql
CREATE TRIGGER "reptg_release_group_secondary_type"
AFTER INSERT OR DELETE OR UPDATE ON "release_group_secondary_type"
FOR EACH ROW EXECUTE PROCEDURE "recordchange" ();
CREATE TRIGGER "reptg_release_group_secondary_type"
AFTER INSERT OR DELETE OR UPDATE ON "release_group_secondary_type_join"
FOR EACH ROW EXECUTE PROCEDURE "recordchange" ('verbose');
The fix is quite easy, but the big question is: what is running on production server? How this script hasn't failed on production server?
Bug
Closed
Normal
Replication trigger for release_group_secondary_type_join is misnamed and duplicates trigger for release_group_secondary_type
According to Postgresql documentation, a trigger name has to be unique, but only for a given table.
So the current script doesn't generate an error. And is what has been run on production server.