[Bucardo-general] problem with referential integrity.

[Greg Sabino Mullane]

> I have setup to very simple tables with a foreign key from one to the
> other. The foreign key rules are that ON UPDATE - CASCADE the change.
> This means that when updating the "referred to" table, every "referring"
> record in the other tables is automagically updated.
> 
> This works beautifully - until - i replicate with bucardo. The problem
> is that bucardo is somehow inhibiting the cascade rule and so while the
> referred to table is update, the referring records are not - essentially
> creating a referential integrity problem. Actually the problem does not
> even get triggered as a error. nasty.

Bucardo replicates the data only. If two tables are logically related,
such as with a foreign key, then they *must* be part of the same sync so
that they get replicated together in one transaction, and all the data
remains tied together.

-- 
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: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090824/c5c1ef9a/attachment.bin