creating a new trigger for a table on a slave host - Mailing list pgsql-sql

From rverghese
Subject creating a new trigger for a table on a slave host
Date
Msg-id 1338919219829-5711310.post@n5.nabble.com
Whole thread Raw
List pgsql-sql
I need to modify my database schema and create a new trigger function. I know
that triggers are suppressed on the slave once Slony starts up. However
since slony is now already running on the slave, if I create a new trigger
there, it will not be suppressed. What is the best practice for creating a
trigger on the slave? Should you take the table out of replication, create
trigger , then add the table back in? Is there some other way to do it?
Thanks
RV

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/creating-a-new-trigger-for-a-table-on-a-slave-host-tp5711310.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


pgsql-sql by date:

Previous
From: Jan Eskilsson
Date:
Subject: Re: How to use hstore
Next
From: John Fabiani
Date:
Subject: defaults in a function