Home > Archive > Slony1 PostgreSQL Replication > August 2005 > Slony and triggers?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Slony and triggers?
Ujwal S. Setlur

2005-08-10, 11:26 am

How does slony treat triggers on tables? I have some
triggers on some tables (before and after insert), and
slony seems to wipe out those triggers on the slave
node. They are still there on the master node. When
the slave is promoted to the master, do I need to
manually put my triggers back in?

Thanks,

Ujwal
Brad Nicholson

2005-08-10, 11:26 am

Ujwal S. Setlur wrote:

>How does slony treat triggers on tables? I have some
>triggers on some tables (before and after insert), and
>slony seems to wipe out those triggers on the slave
>node. They are still there on the master node. When
>the slave is promoted to the master, do I need to
>manually put my triggers back in?
>
>
>


http://linuxfinances.info/info/faq.html#AEN42290

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
Ujwal S. Setlur

2005-08-10, 11:26 am

Oops, didn't read the FAQ. Thanks.

-u

--- Brad Nicholson <bnichols-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org> wrote:

> Ujwal S. Setlur wrote:
>=20
> some
> and
>=20
> http://linuxfinances.info/info/faq.html#AEN42290
>=20
> --=20
> Brad Nicholson 416-673-4106
> Database Administrator, Afilias Canada Corp.
>=20
>=20
> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
>

http://gborg.postgresql.org/mailman.../slony1-general
>=20

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com