Re: PostgreSQL - Ordering Table based of Foreign Key

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com>, Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: Thomas Kellerer <shammat(at)gmx(dot)net>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL - Ordering Table based of Foreign Key
Date: 2021-10-03 16:19:00
Message-ID: d8962f58-42fb-ec14-4fed-75f625843043@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/3/21 7:40 AM, FOUTE K. Jaurès wrote:
> Thanks for your input but I want to make a delete with where clause

Then Thomas Kellerer's suggestion of having "ON DELETE CASCADE" on the
FK would seem to be what you need. If not then you will need to provide
more information about what you are trying to achieve?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message FOUTE K. Jaurès 2021-10-03 16:24:14 Re: PostgreSQL - Ordering Table based of Foreign Key
Previous Message FOUTE K. Jaurès 2021-10-03 14:40:33 Re: PostgreSQL - Ordering Table based of Foreign Key