count on cascading deletes

Поиск
Список
Период
Сортировка
От Eildert Groeneveld
Тема count on cascading deletes
Дата
Msg-id 1409935755.12461.6.camel@fli.bund.de
обсуждение исходный текст
Ответы Re: count on cascading deletes  (Kevin Grittner <kgrittn@ymail.com>)
Re: count on cascading deletes  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: count on cascading deletes  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-general
Dear All

prior to issuing a cascading delete in an interactive program
I would like to retrieve from Postgresql what is involved in the
particular delete, so that this can be printed to the console
and the user can be asked:

   This is what your delete would do in the database:
   deleting panel = 123 would imply deleting the following children:
                  in foo: 123    records
                  in fuu: 123456 records

   do you really want to do this? (y/N)

As this is a general problem, I would assume, that someone has written
a function that would do that. Unfortunately, no luck with google.

Thanks in advance

Tred





В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Employee modeling question
Следующее
От: Cal Heldenbrand
Дата:
Сообщение: Querying a time range across multiple partitions