count on cascading deletes - Mailing list pgsql-general

From Eildert Groeneveld
Subject count on cascading deletes
Date
Msg-id 1409935755.12461.6.camel@fli.bund.de
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Employee modeling question
Next
From: Cal Heldenbrand
Date:
Subject: Querying a time range across multiple partitions