Postgres Pro
Downloads
Home   >   mailing lists

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

From FOUTE K. Jaurès
Subject Re: PostgreSQL - Ordering Table based of Foreign Key
Date
Msg-id CAHQ1jfdC=WLoDNMFtxNf5wW31QWcYefrnBhO_ocg=u_ruv=8Tg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL - Ordering Table based of Foreign Key  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: PostgreSQL - Ordering Table based of Foreign Key
List pgsql-general
Tree view
I need to delete data from about 100 table in the production system for a specific client without stopping application.

On Sun, 3 Oct 2021, 17:19 Adrian Klaver, <adrian.klaver@aklaver.com> wrote:
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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL - Ordering Table based of Foreign Key
Next
From: Joao Miguel Ferreira
Date:
Subject: pg_dump save command in output