Search Postgresql Archives

Re: PostgreSQL - Ordering Table based of Foreign Key

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

Subject: Re: PostgreSQL - Ordering Table based of Foreign Key
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Sun, 3 Oct 2021 09:19:00 -0700
Cc: Thomas Kellerer <shammat@xxxxxxx>, PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAHQ1jffzXJ_imh5g_34-tpNRVvKB3q=1ogJ=tNW-yRFrwFgVvQ@mail.gmail.com>
References: <CAHQ1jfekP6=H-sEzBucctW4kF-jWyEo_rXRDGVsth3EtMQ5aSg@mail.gmail.com> <553c3b6b-93f0-591e-2a48-0c8ab5344d13@gmx.net> <VisenaEmail.59.40582f0598963470.17c4578691a@tc7-visena> <CAHQ1jffzXJ_imh5g_34-tpNRVvKB3q=1ogJ=tNW-yRFrwFgVvQ@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0

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 theFK would seem to be what you need. If not then you will need to providemore information about what you are trying to achieve?



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

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

Follow-Ups:
- Re: PostgreSQL - Ordering Table based of Foreign Key
  - From: FOUTE K. Jaurès

References:
- PostgreSQL - Ordering Table based of Foreign Key
  - From: FOUTE K. Jaurès
- Re: PostgreSQL - Ordering Table based of Foreign Key
  - From: Thomas Kellerer
- Re: PostgreSQL - Ordering Table based of Foreign Key
  - From: Andreas Joseph Krogh
- Re: PostgreSQL - Ordering Table based of Foreign Key
  - From: FOUTE K. Jaurès

Prev by Date: Re: PostgreSQL - Ordering Table based of Foreign Key
Next by Date: Re: PostgreSQL - Ordering Table based of Foreign Key
Previous by thread: Re: PostgreSQL - Ordering Table based of Foreign Key
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]