Re: continuing with rserv replication

From: "pgsql-admin" <pgsql-admin(at)fc(dot)emc(dot)com(dot)ph>
To: pgsql-admin(at)postgresql(dot)org, manueltrujillo(at)dorna(dot)es
Subject: Re: continuing with rserv replication
Date: 2001-11-03 12:50:43
Message-ID: fc.000f567200f97a34000f567200f97a34.f97acb@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

manueltrujillo(at)dorna(dot)es writes:
>Anybody know if is possible to make more of one table "active for
>trigger" with the MasterAddTable program utilitie?
>Actually, only one table with one field is allowed for trigger changes on
>the table, and I want to make more of one field for trigger into a table.

I don't think that is possible. I read the code (RServ.pm specifically).

sub DoDelete
{
[...]
my $sql = "delete from $tabname where $Stables{$tabname}->[1] =
'$key'";
[...]
}

Here you can see that you are only allowed to use one field. In the above
code only one field is
used for deleting a tuple on the slave database (i.e. delete from table
where single_field = value).

sherwin

Browse pgsql-admin by date

  From Date Subject
Next Message Ferdinand Smit 2001-11-05 10:58:10 The patch-mailingslist
Previous Message GB Clark II 2001-11-03 00:53:37 Re: FreeBSD upgrade causes performance degredation