Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL - Ordering Table based of Foreign Key - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: PostgreSQL - Ordering Table based of Foreign Key
Date
Msg-id VisenaEmail.59.40582f0598963470.17c4578691a@tc7-visena
Whole thread Raw
In response to Re: PostgreSQL - Ordering Table based of Foreign Key  (Thomas Kellerer <shammat@gmx.net>)
Responses Re: PostgreSQL - Ordering Table based of Foreign Key
List pgsql-general
Tree view
På søndag 03. oktober 2021 kl. 10:49:49, skrev Thomas Kellerer <shammat@gmx.net>:
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)
 
There is TRUNCATE ... CASCADE
https://www.postgresql.org/docs/14/sql-truncate.html
 
--
Andreas Joseph Krogh

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL - Ordering Table based of Foreign Key
Next
From: Christian Ramseyer
Date:
Subject: Re: PostgreSQL CHECK Constraint