🚀 go-pugleaf

create a user 'REPL' in target db (with grants to aal tables) and set user
to 'REPL' is settings
although this is mentioned in the manual it took me quite some to figure it
out :-)
in target db triggers have statement 'if (user <> 'REPL') then ......'
hth
Frank Bruin
PSO Beheer
fbruin@peterson.nl
0223-685151
"Ron C." <rcraven@bigpond.net.au> wrote in message
news:3c83544b$2_2@dnews...
> I have two sites that require two way data replication
>
> One table has a primary key consisting of two fileds
>         -a generated integer REQUEST_NUM
>         -a country code CCD
>
> This combination is used as the tracking number throughout the
application.
>
> As each country is free to create requests , if country FRN creates a
> request
>         REQUEST_NUM=32121 and CCD=FRN
> and then country ESP creates a request
>         REQUEST_NUM=42121 and CCD=ESP
>
> When the new ESP gets replicated to FRN, will its REQUEST_NUM
> change to 32122 and the CCD=ESP ?
>
> Is there a way to turn the generator off for replication inserts so that
the
> REQUEST_NUM and CCD values keeo their integrity ?
>
> Any ideas on ways around this ?
>
> thanks for your time
> -Ron
>
>