Re: Slony-I - Update trigger on a replicated table

Поиск
Список
Период
Сортировка
От Plugge, Joe R.
Тема Re: Slony-I - Update trigger on a replicated table
Дата
Msg-id BD69807DAE0CE44CA00A8338D0FDD08302D2B27515@oma00cexmbx03.corp.westworlds.com
обсуждение исходный текст
Ответ на Slony-I - Update trigger on a replicated table  ("Plugge, Joe R." <JRPlugge@west.com>)
Ответы Re: Slony-I - Update trigger on a replicated table  (chirag.dave@gmail.com)
Список pgsql-admin
Nevermind ... I RTFM ...

echo "alter table mytable ENABLE REPLICA TRIGGER check_lockout;" | psql mydb

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Plugge, Joe R.
Sent: Thursday, May 13, 2010 4:02 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Slony-I - Update trigger on a replicated table

Anyone know if it is possible to create an update trigger on the destination side of a replicated table in Slony-I and
havethe replication itself cause the trigger to fire? I was able to add the trigger but when run the test transaction
through,it does not seem to be firing.  It works on the non-replicated version of the solution. 

Running postgres 8.4.1 and Slony-I 2.0.3


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Plugge, Joe R."
Дата:
Сообщение: Slony-I - Update trigger on a replicated table
Следующее
От: chirag.dave@gmail.com
Дата:
Сообщение: Re: Slony-I - Update trigger on a replicated table