Hi, I had raised the concern on psycopg2 ( https://github.com/psycopg/psycopg2/issues/661#issuecomment-527739621) and looks like it is a bug in pyscopg2. Refer - https://github.com/psycopg/psycopg2/issues/961
We need wait psycopg2 now to get this fixed. On Wed, Sep 4, 2019 at 12:50 PM Holger Kopp-Musick <hk...@gmx.de> wrote: > Hi, > > thank you very much for your advice, I have attached the log. As proposed > I've replaced the original file and restarted the server, yet unfortunately > I'm still unable to get any results for any simple statement (ie SELECT * > FROM table). In my understanding the obj_id is anyhow faulty since there > are no negative values of attrelid in pg_attribute. Running the statement > primary_keys.sql with the proper value returns the requested row (table.id > ). > > Thanks, > Holger > > > Please try to replace the > \web\pgadmin\tools\sqleditor\templates\sqleditor\sql\default\primary_keys.sql > file with the attached file and do not forget to take a backup of the > original file. > > Restart the server and check the issue gets resolved or not. > -- Thanks and Regards, Aditya Toshniwal Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE"
