| From: | "Holger Kopp-Musick" <hkopp(at)gmx(dot)de> |
|---|---|
| To: | "Aditya Toshniwal" <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
| Cc: | "Khushboo Vashi" <khushboo(dot)vashi(at)enterprisedb(dot)com>, pgadmin-support(at)lists(dot)postgresql(dot)org |
| Subject: | Aw: Re: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor |
| Date: | 2019-09-04 12:23:45 |
| Message-ID: | trinity-db8d525e-dcf5-4278-b77e-7e8e1df2786b-1567599825039@3c-app-gmx-bs33 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi Aditya,</div>
<div> </div>
<div>pgAdmin 4.12 is on Windows 10 Enterprise x64 1809, PostgreSQL 10.9 on CentOS Linux 7.6.1810.</div>
<div> </div>
<div>Thanks again,</div>
<div>Holger</div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Mittwoch, 04. September 2019 um 14:01 Uhr<br/>
<b>Von:</b> "Aditya Toshniwal" <aditya(dot)toshniwal(at)enterprisedb(dot)com><br/>
<b>An:</b> "Holger Kopp-Musick" <hkopp(at)gmx(dot)de><br/>
<b>Cc:</b> "pgadmin-support lists.postgresql.org" <pgadmin-support(at)lists(dot)postgresql(dot)org>, "Khushboo Vashi" <khushboo(dot)vashi(at)enterprisedb(dot)com><br/>
<b>Betreff:</b> Re: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor</div>
<div name="quoted-content">
<div>
<div class="gmail_default" style="font-family: verdana , sans-serif;">Hi Holger,</div>
<div class="gmail_default" style="font-family: verdana , sans-serif;"> </div>
<div class="gmail_default" style="font-family: verdana , sans-serif;">Could you please tell us the OS details for both Postgres and pgAdmin ?</div>
</div>
<div class="gmail_quote">
<div class="gmail_attr">On Wed, Sep 4, 2019 at 4:24 PM Holger Kopp-Musick <<a href="mailto:hkopp(at)gmx(dot)de" onclick="parent.window.location.href='mailto:hkopp(at)gmx(dot)de'; return false;" target="_blank">hkopp(at)gmx(dot)de</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div>Hi,</div>
<div> </div>
<div>thank you very much for your help, indeed it looks like a problem with signed/unsigned values. I'll stay with 4.10 meanwhile.</div>
<div> </div>
<div>Best regards,</div>
<div>Holger</div>
<div>
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0.0px 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);">
<div style="margin: 0.0px 0.0px 10.0px;"><b>Gesendet:</b> Mittwoch, 04. September 2019 um 12:27 Uhr<br/>
<b>Von:</b> "Aditya Toshniwal" <<a href="mailto:aditya(dot)toshniwal(at)enterprisedb(dot)com" onclick="parent.window.location.href='mailto:aditya(dot)toshniwal(at)enterprisedb(dot)com'; return false;" target="_blank">aditya(dot)toshniwal(at)enterprisedb(dot)com</a>><br/>
<b>An:</b> "Holger Kopp-Musick" <<a href="mailto:hkopp(at)gmx(dot)de" onclick="parent.window.location.href='mailto:hkopp(at)gmx(dot)de'; return false;" target="_blank">hkopp(at)gmx(dot)de</a>><br/>
<b>Cc:</b> "pgadmin-support <a href="http://lists.postgresql.org" target="_blank">lists.postgresql.org</a>" <<a href="mailto:pgadmin-support(at)lists(dot)postgresql(dot)org" onclick="parent.window.location.href='mailto:pgadmin-support(at)lists(dot)postgresql(dot)org'; return false;" target="_blank">pgadmin-support(at)lists(dot)postgresql(dot)org</a>>, "Khushboo Vashi" <<a href="mailto:khushboo(dot)vashi(at)enterprisedb(dot)com" onclick="parent.window.location.href='mailto:khushboo(dot)vashi(at)enterprisedb(dot)com'; return false;" target="_blank">khushboo(dot)vashi(at)enterprisedb(dot)com</a>><br/>
<b>Betreff:</b> Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor</div>
<div>
<div>
<div class="gmail_default" style="font-family: verdana , sans-serif;">Hi,</div>
<div class="gmail_default" style="font-family: verdana , sans-serif;"> </div>
<div class="gmail_default" style="font-family: verdana , sans-serif;">I had raised the concern on psycopg2 (<a href="https://github.com/psycopg/psycopg2/issues/661#issuecomment-527739621" target="_blank">https://github.com/psycopg/psycopg2/issues/661#issuecomment-527739621</a>) and looks like it is a bug in pyscopg2.</div>
<div class="gmail_default" style="font-family: verdana , sans-serif;">Refer - <a href="https://github.com/psycopg/psycopg2/issues/961" style="font-family: Arial , Helvetica , sans-serif;" target="_blank">https://github.com/psycopg/psycopg2/issues/961</a></div>
<div class="gmail_default" style="font-family: verdana , sans-serif;"> </div>
<div class="gmail_default" style="font-family: verdana , sans-serif;">We need wait psycopg2 now to get this fixed.</div>
</div>
<div class="gmail_quote">
<div class="gmail_attr">On Wed, Sep 4, 2019 at 12:50 PM Holger Kopp-Musick <<a href="mailto:hkopp(at)gmx(dot)de" onclick="parent.window.location.href='mailto:hkopp(at)gmx(dot)de'; return false;" target="_blank">hkopp(at)gmx(dot)de</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px solid rgb(204,204,204);padding-left: 1.0ex;">Hi,<br/>
<br/>
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 (<a href="http://table.id" target="_blank">table.id</a>).<br/>
<br/>
Thanks,<br/>
Holger<br/>
<br/>
> 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.<br/>
> Restart the server and check the issue gets resolved or not.</blockquote>
</div>
<div> </div>
--
<div class="gmail-m_-6424723592377885592gmail_signature">
<div>
<div>
<div>
<div>
<div><font color="#000000" face="verdana, sans-serif" size="2">Thanks and Regards,</font>
<div><span style="background-color: rgb(255,255,255);"><font color="#000000" face="verdana, sans-serif" size="2">Aditya Toshniwal</font></span></div>
<div><font face="verdana, sans-serif"><span style="background-color: rgb(255,255,255);"><font color="#000000" size="2">Software Engineer | EnterpriseDB India | </font></span><span style="color: rgb(0,0,0);">Pune</span></font></div>
<div><font color="#38761d" face="verdana, sans-serif" size="1">"Don't Complain about Heat, Plant a TREE"</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<div> </div>
--
<div class="gmail_signature">
<div>
<div>
<div>
<div>
<div><font color="#000000" face="verdana, sans-serif" size="2">Thanks and Regards,</font>
<div><span style="background-color: rgb(255,255,255);"><font color="#000000" face="verdana, sans-serif" size="2">Aditya Toshniwal</font></span></div>
<div><font face="verdana, sans-serif"><span style="background-color: rgb(255,255,255);"><font color="#000000" size="2">Software Engineer | EnterpriseDB India | </font></span><span style="color: rgb(0,0,0);">Pune</span></font></div>
<div><font color="#38761d" face="verdana, sans-serif" size="1">"Don't Complain about Heat, Plant a TREE"</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 7.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron.Wildt | 2019-09-06 17:43:55 | config_distro.py missing in pgadmin4 v4.12 |
| Previous Message | Aditya Toshniwal | 2019-09-04 12:01:52 | Re: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor |