| 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: | Whole Thread | Raw Message | 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
| 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 |