Received: from lh00.opsion.fr (lh00.opsion.fr [212.73.208.226]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAJ0Ucm03812 for ; Sun, 18 Nov 2001 19:30:39 -0500 (EST) (envelope-from cnliou@eurosport.com) Received: from 10.1.1.8 [10.1.1.8] by lh00.opsion.fr; Mon, 19 Nov 2001 00:30:25 GMT Send-By: 203.66.130.107 with Mozilla/4.78 [en] (Win95; U) To: Subject: Foreign Key Constraint Deletion Order From: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Date: Mon, 19 Nov 2001 00:30:25 GMT Message-id: <200111190030.197e@lh00.opsion.fr> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fAJ0VCn03822 X-Archive-Number: 200111/259 X-Sequence-Number: 5641 I have found from a small number of tests that deletions executed by foreign key constraint does NOT guarantee the detail table to be deleted BEFORE master table. This makes some of my trigger functions assocated with the detail table mulfunction because the trigger function can't find its parent record. Is there any plan to change the foreign key constraint deletion (and update in master-then-detail) order? Thanks you all! CN -------------------------------------------------------- You too can have your own email address from Eurosport. http://www.eurosport.com