Foreign Key Constraint Deletion Order

From: <cnliou(at)eurosport(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Foreign Key Constraint Deletion Order
Date: 2001-11-19 00:30:25
Message-ID: 200111190030.197e@lh00.opsion.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-11-19 02:01:20 Re: Foreign Key Constraint Deletion Order
Previous Message Tom Lane 2001-11-18 19:26:46 Re: System catalogs