From: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
---|---|
To: | Holger Kopp-Musick <hkopp(at)gmx(dot)de> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>, Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
Subject: | Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor |
Date: | 2019-09-04 10:27:45 |
Message-ID: | CAM9w-_kwy8FKZvpJCOJU4JhHOGqMToUQx3eB=Tvo1u-9BZGwpg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 <hkopp(at)gmx(dot)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"
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Kopp-Musick | 2019-09-04 10:54:14 | Aw: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor |
Previous Message | Dave Page | 2019-09-04 08:22:41 | Re: Are there any web-client-side calls to the database from pg admin? |