MIME-Version: 1.0
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Date: Mon, 21 Sep 2020 13:36:47 +0530
Message-ID: 
 <CAM9w-_kOfGC0zQKkaXoHA1yYvzmbv_jYyK07dJBfAv_EgE1cMw@mail.gmail.com>
Subject: [pgAdmin][RM5845] Free query windows hard capped to 1000 results
 sometimes
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="00000000000024321a05afce570e"
Precedence: bulk

--00000000000024321a05afce570e
Content-Type: multipart/alternative; boundary="00000000000024321905afce570c"

--00000000000024321905afce570c
Content-Type: text/plain; charset="UTF-8"

Hi Hackers,

Attached is the patch to fix the issue where the query tool is not fetching
more than 1000 rows. The issue occurs only when a table does not have any
primary key.

Please review.

-- 
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

--00000000000024321905afce570c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif">Hi Hackers,</div><div class=3D"gmail_default" style=3D"font-fam=
ily:verdana,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fon=
t-family:verdana,sans-serif">Attached is the patch to fix the issue where t=
he query tool is not fetching more than 1000 rows. The issue occurs only wh=
en a table does not have any primary key.</div><div class=3D"gmail_default"=
 style=3D"font-family:verdana,sans-serif"><br></div><div class=3D"gmail_def=
ault" style=3D"font-family:verdana,sans-serif">Please review.</div><div><br=
></div>-- <br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"=
gmail_signature"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr"><div dir=3D"ltr"><div><font size=3D"2" color=3D"#000000" face=3D"=
arial, sans-serif">Thanks,</font><div><span style=3D"color:rgb(34,34,34)"><=
span style=3D"color:rgb(18,22,70)"><font face=3D"arial, sans-serif">Aditya =
Toshniwal</font></span></span><font size=3D"2" color=3D"#000000" face=3D"ve=
rdana, sans-serif"><br></font></div><div><span style=3D"color:rgb(18,22,70)=
;font-family:Arial,sans-serif">pgAdmin hacker</span><font size=3D"2" color=
=3D"#000000" style=3D"font-family:verdana,sans-serif">=C2=A0| </font><font =
size=3D"2" color=3D"#000000" face=3D"arial, sans-serif">Sr. Software Engine=
er</font><font size=3D"2" color=3D"#000000"><font face=3D"verdana, sans-ser=
if"> | </font><a href=3D"http://edbpostgres.com" target=3D"_blank"><font fa=
ce=3D"arial, sans-serif" color=3D"#000000"><b>edbpostgres.com</b></font></a=
></font></div><div><font color=3D"#38761d" size=3D"1"><font face=3D"arial, =
sans-serif">&quot;Don&#39;t Complain about Heat, Plant a TREE&quot;</font><=
/font></div></div></div></div></div></div></div></div></div>

--00000000000024321905afce570c--

--00000000000024321a05afce570e
Content-Type: application/octet-stream; name="RM5845.patch"
Content-Disposition: attachment; filename="RM5845.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_kfc8x9710>
X-Attachment-Id: f_kfc8x9710

ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci91dGlscy9pc19xdWVyeV9y
ZXN1bHRzZXRfdXBkYXRhYmxlLnB5IGIvd2ViL3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9yL3V0aWxz
L2lzX3F1ZXJ5X3Jlc3VsdHNldF91cGRhdGFibGUucHkKaW5kZXggMDEzYzA1ZGE4Li45OWM4ZmU1
M2QgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci91dGlscy9pc19xdWVy
eV9yZXN1bHRzZXRfdXBkYXRhYmxlLnB5CisrKyBiL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRv
ci91dGlscy9pc19xdWVyeV9yZXN1bHRzZXRfdXBkYXRhYmxlLnB5CkBAIC03NSwxNyArNzUsMTYg
QEAgZGVmIGlzX3F1ZXJ5X3Jlc3VsdHNldF91cGRhdGFibGUoY29ubiwgc3FsX3BhdGgpOgogICAg
ICAgICBpc19yZXN1bHRzZXRfdXBkYXRhYmxlID0gaGFzX29pZHMgb3IgKHByaW1hcnlfa2V5cyBp
cyBub3QgTm9uZSBhbmQKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICBsZW4ocHJpbWFyeV9rZXlzKSAhPSAwKQogCi0gICAgICAgIGlmIGlzX3Jlc3VsdHNldF91
cGRhdGFibGU6Ci0gICAgICAgICAgICBjb2x1bW5fdHlwZXMgPSBnZXRfY29sdW1uc190eXBlcyhj
b2x1bW5zX2luZm89Y29sdW1uc19pbmZvLAotICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgdGFibGVfb2lkPXRhYmxlX29pZCwKLSAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIGNvbm49Y29ubiwKLSAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIGhhc19vaWRzPWhhc19vaWRzLAotICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgaXNfcXVlcnlfdG9vbD1UcnVlKQotICAg
ICAgICAgICAgcmV0dXJuIFRydWUsIGhhc19vaWRzLCBwcmltYXJ5X2tleXMsIFwKLSAgICAgICAg
ICAgICAgICBwa19uYW1lcywgdGFibGVfb2lkLCBjb2x1bW5fdHlwZXMKLSAgICAgICAgZWxzZToK
KyAgICAgICAgaWYgbm90IGlzX3Jlc3VsdHNldF91cGRhdGFibGU6CiAgICAgICAgICAgICBfc2V0
X2FsbF9jb2x1bW5zX25vdF9lZGl0YWJsZShjb2x1bW5zX2luZm89Y29sdW1uc19pbmZvKQotICAg
ICAgICAgICAgcmV0dXJuIHJldHVybl9ub3RfdXBkYXRhYmxlKCkKKworICAgICAgICBjb2x1bW5f
dHlwZXMgPSBnZXRfY29sdW1uc190eXBlcyhjb2x1bW5zX2luZm89Y29sdW1uc19pbmZvLAorICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB0YWJsZV9vaWQ9dGFibGVfb2lk
LAorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjb25uPWNvbm4sCisg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGhhc19vaWRzPWhhc19vaWRz
LAorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBpc19xdWVyeV90b29s
PVRydWUpCisgICAgICAgIHJldHVybiBpc19yZXN1bHRzZXRfdXBkYXRhYmxlLCBoYXNfb2lkcywg
cHJpbWFyeV9rZXlzLCBcCisgICAgICAgICAgICBwa19uYW1lcywgdGFibGVfb2lkLCBjb2x1bW5f
dHlwZXMKICAgICBlbHNlOgogICAgICAgICByYWlzZSBJbnRlcm5hbFNlcnZlckVycm9yKFNFUlZF
Ul9DT05ORUNUSU9OX0NMT1NFRCkKIAo=
--00000000000024321a05afce570e--