violation of refrential integrity - Mailing list pgsql-chat
From | amit singh |
---|---|
Subject | violation of refrential integrity |
Date | |
Msg-id | 20050203154656.271B7164005@ws1-4.us4.outblaze.com Whole thread Raw |
List | pgsql-chat |
<div><font face="Arial" size="2">I'm using eRserver on Postgres 7.2-3 version for doing replication on a 2-node cluster (master/slave).</font></div><div><fontface="Arial" size="2"></font> </div><div><font face="Arial" size="2">I was facing theproblem of refrential integrity so gone through a online document <font color="blue">(Hacking the refrential integrityby Joel Burton</font>) in Tech Docs Knowledge base of Postgres , which talks about playing with the pg_triggertable and disabling the field (tgenabled = FALSE ) temporarily to get rid away from triggers (foriegn key constraints).</font></div><div><fontface="Arial" size="2">After making the changes I properly shutdown the database and startedit up but nothing happens . </font></div><div><font face="Arial" size="2"></font> </div><div><font face="Arial" size="2">Linkto the Tech doc: <a href="http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php">http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php</a></font></div><div><font color="red"face="Arial" size="2"></font> </div><div><font color="red" face="Arial" size="2"> ERROR:violation of refrentialintegrity key refrenced from <table2> is not found in <table 1></font></div><div><font color="red"face="Arial" size="2"></font> </div><div><font face="Arial" size="2"> Where table1 is parent of table2.</font></div><div><fontface="Arial" size="2">CAUSE OF ERROR: we are trying to insert something in table2 which isnot there in table1.</font></div><div><font face="Arial" size="2"></font> </div><div><font color="blue" face="Arial" size="2">MYQUERY: Document talks about disabling the tgenabled field on pg_trigger will solve the problem of refrential integrityas it will blindly go and make entries in the table by restricting the triggers to get fired upon INSERTION,DELETIONand UPDATION. It also says that pg_dump works in the same way so that table data can be inserted in anyorder without having to worry about refrential integrity rule.</font></div><div><font color="blue" face="Arial" size="2"></font> </div><div><fontcolor="blue" face="Arial" size="2">So, is this the version(7.2-3) which is not supportingor something else.</font></div><div><font color="#0000ff" face="Arial" size="2"></font> </div><div><font color="#0000ff"face="Arial" size="2">A quick reply will be highly appreciated.</font></div><div><font color="#0000ff" face="Arial"size="2"></font> </div><div><font color="black" face="Arial" size="2">Thanks & Regds,</font></div><div><fontcolor="black" face="Arial" size="2">Amit Singh.</font></div><div><font face="Arial" size="2"></font> </div><br/> -- <p>___________________________________________________________<br />Sign-up for Ads Freeat Mail.com<br /><a href="http://mail01.mail.com/scripts/payment/adtracking.cgi?bannercode=adsfreejump01" target="_blank">http://www.mail.com/?sr=signup</a>
pgsql-chat by date: