Re: foreign key on delete cascade order?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: George Woodring <george(dot)woodring(at)iglass(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: foreign key on delete cascade order?
Date: 2022-03-10 15:56:43
Message-ID: 649664.1646927803@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

George Woodring <george(dot)woodring(at)iglass(dot)net> writes:
> When using FOREIGN KEY ON DELETE CASCADE, is there an order the entries are
> being deleted?

No, there's no particular attempt to order the deletions. Each cascaded
delete ought to be removing a disjoint set of rows in the referencing
table, so I'm not quite sure why order should matter.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Juhasz 2022-03-10 16:18:06 [pgpool] invalid read kind
Previous Message George Woodring 2022-03-10 15:44:40 foreign key on delete cascade order?