Quick Links

PostgreSQL - Ordering Table based of Foreign Key

From:	FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com>
To:	PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject:	PostgreSQL - Ordering Table based of Foreign Key
Date:	2021-10-03 07:48:13
Message-ID:	CAHQ1jfekP6=H-sEzBucctW4kF-jWyEo_rXRDGVsth3EtMQ5aSg@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: PostgreSQL - Ordering Table based of Foreign Key at 2021-10-03 08:45:38 from Karsten Hilbert
Re: PostgreSQL - Ordering Table based of Foreign Key at 2021-10-03 08:49:49 from Thomas Kellerer
Re: PostgreSQL - Ordering Table based of Foreign Key at 2021-10-03 21:32:55 from David G. Johnston

Browse pgsql-general by date

	From	Date	Subject
Next Message	Karsten Hilbert	2021-10-03 08:45:38	Re: PostgreSQL - Ordering Table based of Foreign Key
Previous Message	Shaozhong SHI	2021-10-03 07:31:13	PostgreSQL CHECK Constraint