MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 14 May 2026 16:05:48 -0400
Message-ID: 
 <CANzqJaB2NCCvyigAWH3=1G=2A-oybCo-oQXxWF4UuniCebqhPQ@mail.gmail.com>
Subject: Are these metadata ALTER TABLE commands transactionally safe?
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000433590651cca0b8"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaB2NCCvyigAWH3%3D1G%3D2A-oybCo-oQXxWF4UuniCebqhPQ%40mail.gmail.com>
Precedence: bulk

--0000000000000433590651cca0b8
Content-Type: text/plain; charset="UTF-8"

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;

I don't trust the validity of synthetic tests when Prod is ill-behaved JDBC
connections.

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

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

<div dir=3D"ltr"><div>PG 17.9</div><div><br></div><div><font face=3D"monosp=
ace">BEGIN;</font></div><div><font face=3D"monospace">ALTER TABLE x RENAME =
TO x_hold;<br>ALTER TABLE y.x SET SCHEMA a;<br>ALTER TABLE x OWNER TO foo;<=
/font></div><div><font face=3D"monospace">COMMIT;</font></div><div><br></di=
v><div>I don&#39;t trust the validity of synthetic tests when Prod is ill-b=
ehaved JDBC connections.</div><div><br></div><span class=3D"gmail_signature=
_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data-smar=
tmail=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and b=
utter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;R=
edacted&gt; lobster!</div></div></div></div></div></div>

--0000000000000433590651cca0b8--