pgadmin-org / pgadmin-org/pgadmin4

PGAdmin keeps saying tables/views/procedures are missing when they are not.

Open
#10,058 7 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Bug
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

When right clicking on a table/view/procedure I wish to interact with or modify, PGAdmin sometimes claims it doesn't exist.

Sometimes the tables/views/procedures fail to showcompletely, giving the alarming impression that they have been dropped.

To Reproduce

Steps to reproduce the behavior:
This behaviour is random and I cannot reliably reproduce it.

Interacting with a element in the GUI is triggering it. Executing code is fine.

Expected behavior

The GUI should react correctly and open the element I have clicked.

Error message

In this example, I have attempted to edit a stored procedure. I literally edited it just fine about 2 minutes before trying again and I get this error.

Image

Desktop (please complete the following information):

  • OS: Windows 11
  • pgAdmin version: 9.15
  • Mode: Desktop
  • Package type: Windows .exe installer

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the pgAdmin desktop GUI flow for right-clicking tables, views, and procedures, using the Windows 11 and pgAdmin 9.15 details as the test environment. Investigate why objects intermittently appear missing or fail to open, noting that the reporter cannot reliably reproduce it and that executing code works. Done means the GUI consistently opens existing objects and does not incorrectly report them as missing.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
database, desktop
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.