Aw: Re: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

Hi Aditya,

pgAdmin 4.12 is on Windows 10 Enterprise x64 1809, PostgreSQL 10.9 on CentOS Linux 7.6.1810.

Thanks again,

Holger

Gesendet: Mittwoch, 04. September 2019 um 14:01 Uhr

Von: "Aditya Toshniwal" <[email protected]>

An: "Holger Kopp-Musick" <[email protected]>

Cc: "pgadmin-support lists.postgresql.org" <[email protected]>, "Khushboo Vashi" <[email protected]>

Betreff: Re: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

Hi Holger,

Could you please tell us the OS details for both Postgres and pgAdmin ?

On Wed, Sep 4, 2019 at 4:24 PM Holger Kopp-Musick <[email protected] > wrote:

Hi,

thank you very much for your help, indeed it looks like a problem with signed/unsigned values. I'll stay with 4.10 meanwhile.

Best regards,

Holger

Gesendet: Mittwoch, 04. September 2019 um 12:27 Uhr

Von: "Aditya Toshniwal" <[email protected] >

An: "Holger Kopp-Musick" <[email protected] >

Cc: "pgadmin-support lists.postgresql.org " <[email protected] >, "Khushboo Vashi" <[email protected] >

Betreff: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

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 <[email protected] > 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"

--

Thanks and Regards,

Aditya Toshniwal

Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"