I'm using eRserver on Postgres 7.2-3 version for doing replication on a 2-node cluster (master/slave).
I was facing the problem of refrential integrity so gone through a online document (Hacking the refrential integrity by Joel Burton) in Tech Docs Knowledge base of Postgres , which talks about playing with the pg_trigger table and disabling the field (tgenabled = FALSE ) temporarily to get rid away from triggers (foriegn key constraints).
After making the changes I properly shutdown the database and started it up but nothing happens .
ERROR:violation of refrential integrity key refrenced from <table2> is not found in <table 1>
Where table1 is parent of table2.
CAUSE OF ERROR: we are trying to insert something in table2 which is not there in table1.
MY QUERY: Document talks about disabling the tgenabled field on pg_trigger will solve the problem of refrential integrity as it will blindly go and make entries in the table by restricting the triggers to get fired upon INSERTION,DELETION and UPDATION. It also says that pg_dump works in the same way so that table data can be inserted in any order without having to worry about refrential integrity rule.
So, is this the version(7.2-3) which is not supporting or something else.
A quick reply will be highly appreciated.
Thanks & Regds,
Amit Singh.
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://www.mail.com/?sr=signup