Re: PostgreSQL - Ordering Table based of Foreign Key

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL - Ordering Table based of Foreign Key
Date: 2021-10-03 08:49:49
Message-ID: 553c3b6b-93f0-591e-2a48-0c8ab5344d13@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

FOUTE K. Jaurès schrieb am 03.10.2021 um 09:48:
> I want to order tables based on the foreign key so that I can delete
> tables one by one without facing "ERROR: update or delete on table
> "table" violates foreign key constraint. DETAIL: Key is still
> referenced from table"

You can create the foreign key constraints with the "ON DELETE CASCADE" option.
Then Postgres will handle dependencies automatically for you.

But that means that *all* DELETEs will be cascaded.

Unfortunately, there is no DELETE FROM ... CASCADE option (similar to DROP)

Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2021-10-03 09:26:05 Re: PostgreSQL - Ordering Table based of Foreign Key
Previous Message Karsten Hilbert 2021-10-03 08:45:38 Re: PostgreSQL - Ordering Table based of Foreign Key