ERD parent_child relation issue

[RajabSakalaki]

Please note that security bugs or issues should be reported to [email protected].

the ERD tool fail to open a file once there is a relation parent_child in the same table1(pk , name_, parent_id)
if the parent_id reference the same table table1(pk) it fail

A clear and concise description of what the bug is.

**To Reproduce**

create a table as above and foreign key

Error message

tmp.json

still loading.....

Screenshots

If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. Windows 10
• Version: 22H2
• Mode: Desktop
• Package type: Python

[pms967]

+1, Confirmed.

I removed from the DB the only self-referring relationship (FK to PK of the same table) I had added on the project, re-generated the ERD, saved it to a .pgerd file, and now the new file can be loaded without problems (*).

Interestingly enough, if I remove the relationship ONLY on the ERD (but not on the actual DB) and save the modified .pgerd file, the problem is still there.

(*) The problem with saving images #8424 remains, though. That's likely unrelated.

[RohitBhati8269]

Tested and verified on snapshot build: https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2025-02-25/
Package: wheel
Environment: macOs Sequoia 15.0.1