[Bucardo-general] Question re bucardo capabilities

[Greg Sabino Mullane]

> To put this another way, I need to synchronize INSERT and UPDATE
> but not DELETE operations. Ideally I would like to control this
> on a per-table basis.

Yes, you can do this by writing a custom trigger via the 
bucardo_custom_trigger table. Basically, your trigger will be 
identical to the default bucardo_add_delta one, but have a 
clause at the top that states (paraphrasing):

if opmode = delete then return
(else populate bucardo_delta)

You could also look into dropping the "OR DELETE" bit from each 
Bucardo trigger on the tables you care about. Bucardo will 
recreate such triggers as needed if they are totally removed, 
but changing when it fires should allow you to sneakily subvert 
its purpose.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100217/c9d0adae/attachment.bin