Received: from hotmail.com (f57.law4.hotmail.com [216.33.149.57]) by hub.org (8.9.3/8.9.3) with SMTP id TAA45809 for ; Wed, 12 Apr 2000 19:04:22 -0400 (EDT) (envelope-from arindam_guha@hotmail.com) Received: (qmail 60720 invoked by uid 0); 12 Apr 2000 23:03:51 -0000 Message-ID: <20000412230351.60719.qmail@hotmail.com> Received: from 136.165.47.48 by www.hotmail.com with HTTP; Wed, 12 Apr 2000 16:03:51 PDT X-Originating-IP: [136.165.47.48] From: "Arindam Guha" To: pgsql-sql@postgresql.org Subject: foreign key Date: Wed, 12 Apr 2000 19:03:51 EDT Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-Archive-Number: 200004/131 How to avoid updation anomaly like this : While trying to update in the parent table it says child record exists and while trying to update in the child table it says parent record exists I am trying to update the foreign key column in both the tables ? Also how to delete a foreign key constraint ? Thanks Arindam ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com