[Bucardo-general] support for BLOBs (OID) data type

Greg Sabino Mullane greg at endpoint.com
Fri Jan 15 14:42:26 UTC 2010


> Does Bucardo support the synchonization of BLOBs (OID data type) ?

No. Blobs are stored in the system table pg_largeobject, which cannot
have triggers put upon it, making trigger-based systems like Bucardo and
Slony unable to know when things are changed.

I'm working on a partial workaround, but until such time (if any) that
it materializes, you are better off storing your items in a bytea field
in a normal table if you want them replicated.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100115/266cd7a6/attachment.bin 


More information about the Bucardo-general mailing list