Search Postgresql Archives

PostgreSQL - Ordering Table based of Foreign Key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: PostgreSQL - Ordering Table based of Foreign Key
From: FOUTE K. Jaurès <jauresfoute@xxxxxxxxx>
Date: Sun, 3 Oct 2021 08:48:13 +0100

Hello,

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"

Any help is appreciated.

Thank you in advance.

Best regards

Jaurès FOUTE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: PostgreSQL - Ordering Table based of Foreign Key
  - From: David G. Johnston
- Re: PostgreSQL - Ordering Table based of Foreign Key
  - From: Thomas Kellerer
- Re: PostgreSQL - Ordering Table based of Foreign Key
  - From: Karsten Hilbert

Prev by Date: PostgreSQL CHECK Constraint
Next by Date: Re: PostgreSQL - Ordering Table based of Foreign Key
Previous by thread: PostgreSQL CHECK Constraint
Next by thread: Re: PostgreSQL - Ordering Table based of Foreign Key
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux