Are these metadata ALTER TABLE commands transactionally safe?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Are these metadata ALTER TABLE commands transactionally safe?
Date: 2026-05-14 20:05:48
Message-ID: CANzqJaB2NCCvyigAWH3=1G=2A-oybCo-oQXxWF4UuniCebqhPQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Klaver 2026-05-14 20:11:45 Re: Alter the datatype on all tables present in the database (bigint to varchar)
Previous Message Ron Johnson 2026-05-14 17:20:12 Re: Alter the datatype on all tables present in the database (bigint to varchar)