creating a new trigger for a table on a slave host

Поиск
Список
Период
Сортировка
От rverghese
Тема creating a new trigger for a table on a slave host
Дата
Msg-id 1338919219829-5711310.post@n5.nabble.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Jan Eskilsson
Дата:
Сообщение: Re: How to use hstore
Следующее
От: John Fabiani
Дата:
Сообщение: defaults in a function