| Foreign Keys in Replication [message #250830] |
Wed, 11 July 2007 08:25  |
Lama
Messages: 45
Registered: February 2006
|
Member |
|
|
Hi Guys,
Am in a situation that i have a multimaster replication installed on 3 main servers... I put all the tables in my system in one group for maintaining the foriegn keys , but now when i do the replication (push the transactions) I got an error that a foreign key was violated, when I disabled the constraint then do replication then enable the constraint again, it worked with me...
So am not sure what should i do to solve this, I mean is there a way to give an order for the inserts of the tables (master table before the detailed table) ...
Thanks in-advance,
|
|
|
|
| Re: Foreign Keys in Replication [message #251063 is a reply to message #250830] |
Thu, 12 July 2007 06:13  |
Lama
Messages: 45
Registered: February 2006
|
Member |
|
|
and if this might help... I checked the update statement which caused the error while pushing in the replication and it's on the master table and not updating the pk of that table !!!!!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
