From: | "Holger Kopp-Musick" <hkopp(at)gmx(dot)de> |
---|---|
To: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Subject: | Negative values for obj_id: SELECT statements throwing errors in query editor |
Date: | 2019-09-03 14:01:23 |
Message-ID: | trinity-daae2144-985d-4a66-99f6-03bd78f38f1c-1567519283688@3c-app-gmx-bs40 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 (full internal statement below, apparently by \web\pgadmin\tools\sqleditor\templates\sqleditor\sql\default\primary_keys.sql):
SELECT at.attname, at.attnum, ty.typname
FROM pg_attribute at LEFT JOIN pg_type ty ON (ty.oid = at.atttypid)
WHERE attrelid=-1769161114::oid AND attnum =
ANY ((SELECT con.conkey FROM pg_class rel LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND con.contype='p' WHERE rel.relkind IN ('r','s','t') AND rel.oid = -1769161114::oid)::oid[])
Strange enough, showing the first 100 rows via the menu works as expected and I couldn't reproduce that error neither on a 9.6 database (on Windows localhost) nor with pgAdmin 4.12 running on Linux (also desktop mode); pgAdmin 4.10 and pgAdmin 3 are also working without flaws.
Any ideas or suggestions?
Thanks in advance,
Holger
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2019-09-03 14:44:24 | pgAdmin - migration |
Previous Message | TedJones | 2019-09-03 11:01:58 | Re: joining tables |