| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | Thomas Kellerer <shammat(at)gmx(dot)net> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL - Ordering Table based of Foreign Key |
| Date: | 2021-10-03 09:26:05 |
| Message-ID: | VisenaEmail.59.40582f0598963470.17c4578691a@tc7-visena |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
På søndag 03. oktober 2021 kl. 10:49:49, skrev Thomas Kellerer <shammat(at)gmx(dot)net
<mailto:shammat(at)gmx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Ramseyer | 2021-10-03 14:01:57 | Re: PostgreSQL CHECK Constraint |
| Previous Message | Thomas Kellerer | 2021-10-03 08:49:49 | Re: PostgreSQL - Ordering Table based of Foreign Key |