pgadmin-org / pgadmin-org/pgadmin4
ERD tool error
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
Greetings
I am on a Windows 11 desktop,
PgAdmin version 9.17
Postgres version is 11.5
I connected correctly to the DB and I was trying to use the ERD for schema to generate a diagram and I got the following error.
error: column att.attgenerated does not exist LINE 36: ...EN (att.attidentity in ('a', 'd')) THEN 'i' WHEN (att.attgen...
Any hints or workaround or patch?
Thanks in advance
Regards
GIancarlo
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing ERD schema generation in pgAdmin 4 against PostgreSQL 11.5 on Windows 11, then trace the query containing att.attgenerated and compare it with the PostgreSQL 11 catalog schema. Done means the ERD tool generates the diagram without the missing-column error, or reports a documented compatibility limitation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 55/100