MIME-Version: 1.0
References: 
 <CACLU5mRsdYaEr+y=rYr6_rHJRoW49vTnSLdrcwwN2K0fONupJg@mail.gmail.com>
 <CAKFQuwa0CdWC2wsaGBdiBd22AvOShy=qnDU-fpkNj_3cfc8RzQ@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwa0CdWC2wsaGBdiBd22AvOShy=qnDU-fpkNj_3cfc8RzQ@mail.gmail.com>
From: Kirk Wolak <wolakk@gmail.com>
Date: Wed, 17 Apr 2024 13:52:57 -0400
Message-ID: 
 <CACLU5mQsPS4-+JZN5DTY_JB7mRZB1CdFbk7VcJV6yDRKZUhXTg@mail.gmail.com>
Subject: Re: Update Help on PREPARE to mention DEALLOCATE
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e7d11006164e8757"
Archived-At: 
 <https://www.postgresql.org/message-id/CACLU5mQsPS4-%2BJZN5DTY_JB7mRZB1CdFbk7VcJV6yDRKZUhXTg%40mail.gmail.com>
Precedence: bulk

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

On Tue, Apr 16, 2024 at 4:42=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Tue, Apr 16, 2024 at 1:27=E2=80=AFPM Kirk Wolak <wolakk@gmail.com> wro=
te:
>
>> Could we make the PREPARE line read
>> ...
>>
> No. That is a syntax excerpt and the prepare command doesn't accept an
> optional deallocate keyword at that position.
>
> If we wanted to improve the psql help here we'd have two options:
> Add to the description:
> prepare a statement for execution (undo this with Deallocate)
>

I  am 100% okay with that.  I would consider DEALLOCATE to be caps so it
looks like a command.

But would leave that to you guys...
Great observations on the other issues.  Not looking to complicate things.
Just enough bread crumbs to link things.

Thanks!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Apr 16, 2024 at 4:42=E2=80=AFPM D=
avid G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.=
johnston@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"l=
tr"><div style=3D"font-family:arial,helvetica,sans-serif"><span style=3D"fo=
nt-family:Arial,Helvetica,sans-serif">On Tue, Apr 16, 2024 at 1:27=E2=80=AF=
PM Kirk Wolak &lt;<a href=3D"mailto:wolakk@gmail.com" target=3D"_blank">wol=
akk@gmail.com</a>&gt; wrote:</span><br></div></div><div class=3D"gmail_quot=
e"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>=
Could we make the PREPARE line read<br></div><div>...</div></div></blockquo=
te><div style=3D"font-family:arial,helvetica,sans-serif">No. That is a synt=
ax excerpt and the prepare command doesn&#39;t accept an optional deallocat=
e keyword at that position.</div><div style=3D"font-family:arial,helvetica,=
sans-serif"><br></div><div style=3D"font-family:arial,helvetica,sans-serif"=
>If we wanted to improve the psql help here we&#39;d have two options:</div=
><div style=3D"font-family:arial,helvetica,sans-serif">Add to the descripti=
on:</div><div style=3D"font-family:arial,helvetica,sans-serif">prepare a st=
atement for execution (undo this with Deallocate)<br></div></div></div></bl=
ockquote><div>=C2=A0</div><div>I=C2=A0 am 100% okay with that.=C2=A0 I woul=
d consider DEALLOCATE to be caps so it looks like a command.</div><div><br>=
</div><div>But would leave that to you guys...</div><div>Great observations=
 on the other issues.=C2=A0 Not looking to complicate things.=C2=A0 Just en=
ough bread crumbs to link things.</div><div><br></div><div>Thanks!<br></div=
></div></div>

--000000000000e7d11006164e8757--