MIME-Version: 1.0
From: Nikhil Mohite <nikhil.mohite@enterprisedb.com>
Date: Wed, 14 Jun 2023 18:13:38 +0530
Message-ID: 
 <CAOBg0AMGqtR9QVkaJuu2x7fccCpFWOzAz56DHAgGdx1-=us7dg@mail.gmail.com>
Subject: Required inputs in issue #6138
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b098bb05fe164dc6"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOBg0AMGqtR9QVkaJuu2x7fccCpFWOzAz56DHAgGdx1-%3Dus7dg%40mail.gmail.com>
Precedence: bulk

--000000000000b098bb05fe164dc6
Content-Type: text/plain; charset="UTF-8"

Hi Hacker,

I am currently working on issue #6138
<https://github.com/pgadmin-org/pgadmin4/issues/6138>, which was fixed
earlier but the fix was not correct so working on it again.
Steps to reproduce the issue:
1. Open *View/Edit Data *for *table1*
2. Open the PSQL tool delete the same *table1 *and recreates the same name
table *table1* and try to re-execute the query from the already opened
*View/Edit
data *panel.
3. pgAdmin throws an error in the Messages tab *List index out of
range *(pgAdmin
query to get table columns from Postgres based on *table oid* which was
deleted and the return result is empty which is not handled in pgAdmin)*.*

Approach to fix this issue:
1. If the user re-executes the query from already opened *View/Edit data* we
should fetch the table details by using *schema and table name (not using
table oid)* and show the newly created table records in the result.
(This will only fix an issue with *View/Edit Data *however if the user
switches to properties or some other panel it user will still get an error
notification with content *"could not find the specified table."*)

-- 
*Thanks & Regards,*
*Nikhil Mohite*
*Senior Software Engineer.*
*EDB Postgres* <https://www.enterprisedb.com/>
*Mob.No: +91-7798364578.*

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

<div dir=3D"ltr">Hi Hacker,<div><br></div><div>I am currently working on is=
sue <a href=3D"https://github.com/pgadmin-org/pgadmin4/issues/6138">#6138</=
a>, which was fixed earlier but the fix was not correct so working on it ag=
ain.</div><div>Steps=C2=A0to reproduce=C2=A0the issue:</div><div>1. Open=C2=
=A0<i>View/Edit Data </i>for <i>table1</i></div><div>2. Open the PSQL tool =
delete the same <i>table1 </i>and recreates the same name table <i>table1</=
i> and try to re-execute=C2=A0the query from the already=C2=A0opened=C2=A0<=
i>View/Edit data </i>panel.</div><div>3. pgAdmin throws an error in the Mes=
sages tab <i>List index out of range </i>(pgAdmin query to get table column=
s from Postgres based on <i>table oid</i> which was deleted and the return =
result is empty which is not handled in pgAdmin)<i>.</i></div><div><i><br><=
/i></div><div>Approach=C2=A0to fix this issue:</div><div>1. If the user re-=
executes=C2=A0the query from already=C2=A0opened <i>View/Edit data</i>=C2=
=A0we should=C2=A0fetch the table details=C2=A0by using <i>schema and table=
 name (not using table oid)</i>=C2=A0and show the newly created table recor=
ds in the result.</div><div>(This will only fix an issue with <i>View/Edit =
Data </i>however if the user switches to properties or some other panel it =
user will still get an error notification with content=C2=A0<i>&quot;could =
not find the specified table.&quot;</i>)</div><div><div><br></div><span cla=
ss=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail=
_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><b><font fa=
ce=3D"arial, sans-serif">Thanks &amp; Regards,</font></b><div><b><font face=
=3D"arial, sans-serif">Nikhil Mohite</font></b></div><div><b><font face=3D"=
arial, sans-serif">Senior Software Engineer.</font></b></div><div><a href=
=3D"https://www.enterprisedb.com/" target=3D"_blank"><b><font face=3D"arial=
, sans-serif">EDB Postgres</font></b></a></div><div><b><font face=3D"arial,=
 sans-serif">Mob.No: +91-7798364578.</font></b></div></div></div></div></di=
v>

--000000000000b098bb05fe164dc6--