jakob / jakob/Postico

Show dependent objects in delete dialog sheet

Open
#77 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

It would be great if the dialog box would show the dependent objects in the delete dialog.
It should be possible to get the dependance tree from the `pg_depend` sys catalog.
The dialog should only show the cascade option if at least one object depends on the db-object.
It should also display the number of dependent objects and have a toggle switch to list these.

I think such a feature would prevent some unintentional `DROP CASCADES` and would be greatly appreciated.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the delete dialog sheet and the database access code that can query PostgreSQL's pg_depend catalog. Trace how dependent objects and cascade deletion are currently handled, then verify that the dialog conditionally shows the cascade option, dependent-object count, and expandable list as described.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
database, desktop
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.