X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 64CA08B9F4D for ; Thu, 3 Feb 2005 15:47:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41830-01 for ; Thu, 3 Feb 2005 15:47:05 +0000 (GMT) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing.us4.outblaze.com [205.158.62.67]) by svr1.postgresql.org (Postfix) with ESMTP id 45C548B9F43 for ; Thu, 3 Feb 2005 15:47:08 +0000 (GMT) Received: from wfilter.us4.outblaze.com (wfilter.us4.outblaze.com [205.158.62.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id 1E00518002B4 for ; Thu, 3 Feb 2005 15:47:09 +0000 (GMT) X-OB-Received: from unknown (205.158.62.50) by wfilter.us4.outblaze.com; 3 Feb 2005 15:47:08 -0000 Received: by ws1-4.us4.outblaze.com (Postfix, from userid 1001) id 271B7164005; Thu, 3 Feb 2005 15:46:56 +0000 (GMT) Content-Type: text/html; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Received: from [164.164.29.46] by ws1-4.us4.outblaze.com with http for amitsingh_cse@mail.com; Thu, 03 Feb 2005 10:46:56 -0500 From: "amit singh" To: "pgsql-chat @ postgresql . org" , pgsql-docs@postgresql.org, "andrew @ libertyrms . info" Cc: balwant.singh@wipro.com, amitkumar.singh@wipro.com Date: Thu, 03 Feb 2005 10:46:56 -0500 Subject: violation of refrential integrity X-Originating-Ip: 164.164.29.46 X-Originating-Server: ws1-4.us4.outblaze.com Message-Id: <20050203154656.271B7164005@ws1-4.us4.outblaze.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.343 tagged_above=0 required=5 tests=HTML_40_50, HTML_MESSAGE, HTML_MIME_NO_HTML_TAG, MIME_HTML_ONLY X-Spam-Level: * X-Archive-Number: 200502/1 X-Sequence-Number: 24
I'm using eRserver on Postgres 7.2-3 versi= on for doing replication on a 2-node cluster (master/slave).
 
I was facing the problem of refrential int= egrity so gone through a online document (Hacking the re= frential 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 =3D FALSE ) temporarily to get ri= d away from triggers (foriegn key constraints).
After making the changes I properly shutdo= wn the database and started it up but nothing happens .
 
Link to the Tech doc: http://tech= docs.postgresql.org/techdocs/hackingreferentialintegrity.php
 
 ERROR:violation of refre= ntial integrity key refrenced from <table2> is  not fo= und  in <table 1>
 
 Where table1 is parent of table2.
CAUSE OF ERROR: we are trying to insert so= mething in table2 which is not there in table1.
 
MY QUERY: Document talks abou= t disabling the tgenabled field on pg_trigger will solve the problem of ref= rential integrity as it will blindly go and make entries in the table by re= stricting the triggers to get fired upon INSERTION,DELETION and UPDATION. I= t also says that pg_dump works in the same way so that table data can be in= serted 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 high= ly appreciated.
 
Thanks & Regds,
Amit Singh.
 

--=20

___________________________________________________________
Sign-up f= or Ads Free at Mail.com
http://www.mail.com/?sr=3Dsignup