Re: Multi-Master AR and Foreign Keys

I thought I would post a follow-up message. Turns out AR initially copies data from the source (master definition site) into the other master sites specified. If data already exists in the table this may cause a problem. So far from what I have learned, it seems best to start with fresh master databases (i.e. no data) and move from there. Perhaps I am wrong on this account - but I jus thought someone might be interested in knowing.

I'm somewhat surprised there is not a really good book out on the market that explains AR in greater detail.

=-Dave L.

dlejeune_at_yahoo.com (David LeJeune) wrote in message news:<f329f8a7.0111190813.d384740_at_posting.google.com>...
> Hi -
>
> Quick question. Does AR require deferrable constraints? When I
> attempt to add an object to a multi-master AR setup, I get the
> following error:
>
> ORA-02292: Integrity Constraint(<CONSTRAINT_NAME) violated - child
> record found.
> ORA-02266: unique/primary keys in table referenced by enabled foreign
> keys.
>
> I assume the replication when I apply my change (i.e. adding the new
> look-up table), attempts to truncate it and then insert the new data.
> This is causing this error on the remote master site. Any ideas? Do
> I have to make my constraints deferrable or something?
>
> Thanks,
> Dave L.
Received on Tue Nov 20 2001 - 09:25:40 CST