Postgres Pro
Downloads
Home   >   mailing lists

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

From FOUTE K. Jaurès
Subject PostgreSQL - Ordering Table based of Foreign Key
Date
Msg-id CAHQ1jfekP6=H-sEzBucctW4kF-jWyEo_rXRDGVsth3EtMQ5aSg@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL - Ordering Table based of Foreign Key
Re: PostgreSQL - Ordering Table based of Foreign Key
Re: PostgreSQL - Ordering Table based of Foreign Key
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: PostgreSQL CHECK Constraint
Next
From: Karsten Hilbert
Date:
Subject: Re: PostgreSQL - Ordering Table based of Foreign Key