CODEWITHSUNDEEP
postgresqldatabase-replicationsymmetricds
Gurpreet Singh
Gurpreet Singh

Reputation: 185

Adding symmetricds to slony slave in Postgres

Can we add triggers to the slave in postgres which is using slony for replication? These additional triggers (which will not be present in master) are needed for some additional work.

Thanks

Upvotes: 0

Views: 89

Answers (1)

Boris Pavlović
Boris Pavlović

Reputation: 64640

Postgresql allows declaration of multiple triggers on a table. They are executed in alphabetical order: https://www.postgresql.org/docs/9.1/static/sql-createtrigger.html

If multiple triggers of the same kind are defined for the same event, they will be fired in alphabetical order by name.

Feel free to add the triggers.

Upvotes: 0

Related Questions