Re: PostgreSQL - Ordering Table based of Foreign Key

Поиск
Список
Период
Сортировка
От FOUTE K. Jaurès
Тема Re: PostgreSQL - Ordering Table based of Foreign Key
Дата
Msg-id CAHQ1jfdC=WLoDNMFtxNf5wW31QWcYefrnBhO_ocg=u_ruv=8Tg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL - Ordering Table based of Foreign Key  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: PostgreSQL - Ordering Table based of Foreign Key
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL - Ordering Table based of Foreign Key
Следующее
От: Joao Miguel Ferreira
Дата:
Сообщение: pg_dump save command in output