MIME-Version: 1.0
References: 
 <CAO+oWtBxAaDxdPOkcf=bTU0D6sDogX_az4SgN-5zKZt-9G=2xQ@mail.gmail.com>
 <CA+OCxozieNmgfoGFq0G0Mxy+bu2Ct6hK9goZA3xtVJm9EaK6HA@mail.gmail.com>
 <CAO+oWtA13KM+jmWm+MkGbmLps2dh3B06mEZu6-PQjZ0ip7+G6g@mail.gmail.com>
 <CA+OCxoxMdX9Lsyugx7=_CZ3Z6K9jxHVTOBu4q=5_1cwgXsP7LQ@mail.gmail.com>
 <CAM9w-_mdXSmj2xv9W2k6hdmdY+3V8rfi4gnjBA_Jy28ZYkza2Q@mail.gmail.com>
 <CA+OCxozSdrD1ziKmfd_xLh72P031vdEo60wZxniyYP9sBLoM7Q@mail.gmail.com>
 <CAM9w-_=tRn_zM6C8Pm6B5w6du8BjdtrRnb1XxX1qyEcaSx4kEg@mail.gmail.com>
 <CA+OCxoz30kYxbska9TFHDKO3kXoervwY6OYE2kcY6b-k6-iYvg@mail.gmail.com>
 <CAM9w-_kjmG0rthcqss2TL+eFtC93qn_5ts_5=Fkqes82VG_EMg@mail.gmail.com>
 <CA+OCxozJpVhOTkPMv3_+EoEto+v+EeL=p1-dxjHFEvJM1EMBEQ@mail.gmail.com>
 <CAM9w-_n9i5fZSzRRNywJiCGv7TSRbSHLv+LVEBR=qn3zczrAxg@mail.gmail.com>
 <CAM9w-_nvA83wZ8m47B3fLswAQygrg1X9tk1g9hyQZEFqoH_zog@mail.gmail.com>
 <CA+OCxowig3kDr7APS0jitjBcE=Mq_vbnUNYYApt6-7_xp9yg6w@mail.gmail.com>
 <CAA-aLv6Lp-zHhnrh-SqzSeO7L8XanNjwhBQpsaP_4SqgwUHcmw@mail.gmail.com>
 <CA+OCxoyH6SNE_T+2p=4sQHHoTzsOOVuT+HEzqZMzgbKRXn_EAA@mail.gmail.com>
 <CAA-aLv54foGwCFYgsEN=tHM=Jzf=HBdsK96X+M0AaKigXh9OTg@mail.gmail.com>
 <CA+OCxoxN3D+tojy+67LNc702oP2JrK9035HtSROYeJErb6EXqw@mail.gmail.com>
 <CAA-aLv4nVeTmGPTtEi15y+Pn-usOoY7KPu594QzQtF9ikG0yYg@mail.gmail.com>
 <CA+OCxoyzADYJLk3XaC7x_+qpRajrujPvhhceoMZLeKqgu=acdg@mail.gmail.com>
 <CAO+oWtBExj5HmywJHs0k_C7J6Wa17=J_JQCA5MXbEK0mpq-NBg@mail.gmail.com>
In-Reply-To: 
 <CAO+oWtBExj5HmywJHs0k_C7J6Wa17=J_JQCA5MXbEK0mpq-NBg@mail.gmail.com>
From: Dave Page <dpage@pgadmin.org>
Date: Thu, 16 May 2024 10:53:36 +0100
Message-ID: 
 <CA+OCxoxqMVUR9JdWSAeZPYxSRpLvZLOED6M3tC1L7GgsnfZ4iQ@mail.gmail.com>
Subject: Re: Regarding feature #6841
To: Anil Sahoo <anil.sahoo@enterprisedb.com>
Cc: Thom Brown <thom@linux.com>,
 Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>,
	pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000236e9706188f36ef"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BOCxoxqMVUR9JdWSAeZPYxSRpLvZLOED6M3tC1L7GgsnfZ4iQ%40mail.gmail.com>
Precedence: bulk

--000000000000236e9706188f36ef
Content-Type: text/plain; charset="UTF-8"

On Wed, 15 May 2024 at 12:33, Anil Sahoo <anil.sahoo@enterprisedb.com>
wrote:

> Hi Team,
>
> I have implemented the Execute query feature and tested it with different
> kinds of test cases.
>
> FYI the PostgreSQL Do block does not work as a single statement when we
> put the cursor inside the block at different positions.
>
> The cursor position is mentioned using pipe('|') and underlined query is
> the active query that will run on click of Execute query button.
>
> I have attached some screenshots for reference.
>
> Please let me know if you have any questions.
>

That is exactly the sort of behaviour I was afraid of :-(. At least we have
safeguards in place to minimise the chances of the user running something
unexpected.

-- 
Dave Page
pgAdmin: https://www.pgadmin.org
PostgreSQL: https://www.postgresql.org
EDB: https://www.enterprisedb.com

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Wed, 15 May 2024 at 12:33, Anil Sa=
hoo &lt;<a href=3D"mailto:anil.sahoo@enterprisedb.com">anil.sahoo@enterpris=
edb.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;bord=
er-left-color:rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi Team,<=
div><br><div>I have implemented the Execute query feature and tested it wit=
h different kinds of test cases.</div><div><br></div><div>FYI the PostgreSQ=
L Do block does not work as a single statement=C2=A0when we put the cursor =
inside the block at different positions.=C2=A0</div><div><br></div><div>The=
 cursor position is mentioned using pipe(&#39;|&#39;) and underlined query =
is the active query that will run on click of Execute query button.<br></di=
v><div><br></div><div>I have attached=C2=A0some screenshots for reference.=
=C2=A0</div><div><br></div><div>Please let me know=C2=A0if you have any que=
stions.</div></div></div></blockquote><div><br></div><div>That is exactly t=
he sort of behaviour I was afraid of :-(. At least we have safeguards in pl=
ace to minimise the chances of the user running something unexpected.</div>=
<div>=C2=A0</div></div><span class=3D"gmail_signature_prefix">-- </span><br=
><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Dave Page<div>=
pgAdmin: <a href=3D"https://www.pgadmin.org" target=3D"_blank">https://www.=
pgadmin.org</a></div><div>PostgreSQL: <a href=3D"https://www.postgresql.org=
" target=3D"_blank">https://www.postgresql.org</a><br><div>EDB:=C2=A0<a hre=
f=3D"https://www.enterprisedb.com" target=3D"_blank">https://www.enterprise=
db.com</a></div><div><br></div></div></div></div></div>

--000000000000236e9706188f36ef--