Re: continuing with rserv replication - Mailing list pgsql-admin

From pgsql-admin
Subject Re: continuing with rserv replication
Date
Msg-id fc.000f567200f97a34000f567200f97a34.f97acb@fc.emc.com.ph
Whole thread Raw
In response to continuing with rserv replication  (Manuel Trujillo <manueltrujillo@dorna.es>)
List pgsql-admin
manueltrujillo@dorna.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


pgsql-admin by date:

Previous
From: Chris Ruprecht
Date:
Subject: Re: [Solution] PG 7.1.3 & MacOS X (10.1)
Next
From: Ferdinand Smit
Date:
Subject: Re: The patch-mailingslist