continuing with rserv replication

От:

Manuel Trujillo <manueltrujillo@dorna.es>

Дата:

31 октября 2001 г. в 06:09:35

Hi.

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.

Thank's.

-- 
Manuel Trujillo         manueltrujillo@dorna.es
Technical Engineer      http://www.motograndprix.com
Dorna Sports S.L.       +34 93 4702864

Re: continuing with rserv replication

От:

"pgsql-admin" <pgsql-admin@fc.emc.com.ph>

Дата:

5 ноября 2001 г. в 11:18:10

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