MIME-Version: 1.0
References: 
 <CANzqJaB2NCCvyigAWH3=1G=2A-oybCo-oQXxWF4UuniCebqhPQ@mail.gmail.com>
 <CAKFQuwbZQ6nquZaw3Xoa2GyFa0_kGzmuVAH71LN7tO-z+sAoAA@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwbZQ6nquZaw3Xoa2GyFa0_kGzmuVAH71LN7tO-z+sAoAA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 14 May 2026 21:03:47 -0400
Message-ID: 
 <CANzqJaAqg37Q7HM6uo=BRE2c6_==kawD8EBO6og_MbTp-ayo4w@mail.gmail.com>
Subject: Re: Are these metadata ALTER TABLE commands transactionally safe?
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b6a3b30651d0c9bb"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaAqg37Q7HM6uo%3DBRE2c6_%3D%3DkawD8EBO6og_MbTp-ayo4w%40mail.gmail.com>
Precedence: bulk

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

On Thu, May 14, 2026 at 5:26=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Thursday, May 14, 2026, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
>> PG 17.9
>>
>> BEGIN;
>> ALTER TABLE x RENAME TO x_hold;
>> ALTER TABLE y.x SET SCHEMA a;
>> ALTER TABLE x OWNER TO foo;
>> COMMIT;
>>
>>
> Define =E2=80=9Ctransactionally safe=E2=80=9D.
>

Any open transactions will still see the original tables.


>
>
>> I don't trust the validity of synthetic tests when Prod is ill-behaved
>> JDBC connections.
>>
>>
> Then do them over a local connection using psql?
>

The applications which I don't want to throw errors are ill-behaved JDBC
connections.  Sorry for the ambiguity.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, May 14, 2026 at 5:26=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:</div><div class=3D"gmail_quote gmail_quot=
e_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Thursday,=
 May 14, 2026, Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com" t=
arget=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; wrote:<br><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>PG 17.9</div><div><=
br></div><div><font face=3D"monospace">BEGIN;</font></div><div><font face=
=3D"monospace">ALTER TABLE x RENAME TO x_hold;<br>ALTER TABLE y.x SET SCHEM=
A a;<br>ALTER TABLE x OWNER TO foo;</font></div><div><font face=3D"monospac=
e">COMMIT;</font></div><div><br></div></div></blockquote><div><br></div><di=
v>Define =E2=80=9Ctransactionally safe=E2=80=9D.</div></blockquote><div><br=
></div><div>Any open transactions will still see the original tables.</div>=
<div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>=C2=
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"=
><div>I don&#39;t trust the validity of synthetic tests when Prod is ill-be=
haved JDBC connections.</div><div><br></div></div></blockquote><div><br></d=
iv><div>Then do them over a local connection using psql?</div></blockquote>=
<div><br></div><div>The applications which I don&#39;t want to throw errors=
 are ill-behaved JDBC connections.=C2=A0 Sorry for the ambiguity.</div><div=
><br></div></div><span class=3D"gmail_signature_prefix">-- </span><br><div =
dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacte=
d&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><di=
v><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--000000000000b6a3b30651d0c9bb--