Re: [SQL] replicating a table in several databases

2008-10-14 Thread zouguanghui
Hi,everybody.I am a new member. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe Sent: Wednesday, October 15, 2008 8:14 AM To: Chris Browne Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] replicating a table in several databases On Fri, Oct

Re: [SQL] replicating a table in several databases

2008-10-14 Thread Scott Marlowe
On Fri, Oct 10, 2008 at 8:59 AM, Chris Browne <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (Gerardo Herzig) writes: >> Hi all. Im facing a situation where i have to replicate a table from >> database A in databases B,C,F and so on. >> >> The first (and only) thing i have in mind is using triggers

Re: [SQL] replicating a table in several databases

2008-10-10 Thread Chris Browne
[EMAIL PROTECTED] (Gerardo Herzig) writes: > Hi all. Im facing a situation where i have to replicate a table from > database A in databases B,C,F and so on. > > The first (and only) thing i have in mind is using triggers with dblink > for comunications with the other DB's. > > I dont even like the

[SQL] replicating a table in several databases

2008-10-10 Thread Gerardo Herzig
Hi all. Im facing a situation where i have to replicate a table from database A in databases B,C,F and so on. The first (and only) thing i have in mind is using triggers with dblink for comunications with the other DB's. I dont even like the idea of replicating tables across databases, but it is