From: | "Holger Kopp-Musick" <hkopp(at)gmx(dot)de> |
---|---|
To: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Cc: | "Khushboo Vashi" <khushboo(dot)vashi(at)enterprisedb(dot)com>, "Aditya Toshniwal" <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
Subject: | Aw: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor |
Date: | 2019-09-04 10:54:14 |
Message-ID: | trinity-a3b26e55-c478-4a9a-939a-697c6936e09f-1567594454014@3c-app-gmx-bs46 |
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>
<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 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 12:27 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: 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,</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_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></body></html>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 4.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Albert Serrallé | 2019-09-04 11:03:23 | Bad Cookies with reverse proxy |
Previous Message | Aditya Toshniwal | 2019-09-04 10:27:45 | Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor |