count on cascading deletes

From: Eildert Groeneveld <eildert(dot)groeneveld(at)fli(dot)bund(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: count on cascading deletes
Date: 2014-09-05 16:49:15
Message-ID: 1409935755.12461.6.camel@fli.bund.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cal Heldenbrand 2014-09-05 17:31:30 Querying a time range across multiple partitions
Previous Message Rich Shepard 2014-09-05 16:39:47 Re: Employee modeling question