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

Поиск
Список
Период
Сортировка
От Holger Kopp-Musick
Тема Aw: Re: Negative values for obj_id: SELECT statements throwingerrors in query editor
Дата
Msg-id trinity-61a782b2-ade3-4eef-8fe8-1e6eef0acab9-1567581620511@3c-app-gmx-bs63
обсуждение исходный текст
Ответ на Re: Negative values for obj_id: SELECT statements throwing errors inquery editor  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Ответы Re: Re: Negative values for obj_id: SELECT statements throwing errorsin query editor  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Список pgadmin-support
Дерево обсуждения 
Hi,

thank you very much for your advice, I have attached the log. As proposed I've replaced the original file and restarted
theserver, yet unfortunately I'm still unable to get any results for any simple statement (ie SELECT * FROM table). In
myunderstanding the obj_id is anyhow faulty since there are no negative values of attrelid in pg_attribute. Running the
statementprimary_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
theattached file and do not forget to take a backup of the original file. 
> Restart the server and check the issue gets resolved or not.
Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: Aidan Hoolachan
Дата:
Сообщение: Are there any web-client-side calls to the database from pg admin?
Следующее
От: Dave Page
Дата:
Сообщение: Re: Are there any web-client-side calls to the database from pg admin?