stgresql.org" , "Khushboo Vashi"
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 <hk...
g>, "Khushboo Vashi" <
> khushboo.va...@enterprisedb.com>
> *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
ot;
Cc: "pgadmin-support lists.postgresql.org" , "Khushboo Vashi"
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) a
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 Kop
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
Hi,
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,
Khushboo
On Tue, Sep 3, 2019 at
Hi,
On Tue, Sep 3, 2019 at 7:31 PM Holger Kopp-Musick wrote:
> Hi,
>
> I'm using pgAdmin 4.12 in desktop mode on Win 10 1809, databases are 10.9
> on CentOS 7.6. When executing any SELECT in the query editor, I get no data
> but the following error message:
> Operator does not exist: - oid
>
>
Hi,
I'm using pgAdmin 4.12 in desktop mode on Win 10 1809, databases are 10.9 on
CentOS 7.6. When executing any SELECT in the query editor, I get no data but
the following error message:
Operator does not exist: - oid
I understand that converting the negative value of attrelid causes that error
