Re: Are these metadata ALTER TABLE commands transactionally safe?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Are these metadata ALTER TABLE commands transactionally safe?
Date: 2026-05-14 21:26:05
Message-ID: CAKFQuwbZQ6nquZaw3Xoa2GyFa0_kGzmuVAH71LN7tO-z+sAoAA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thursday, May 14, 2026, Ron Johnson <ronljohnsonjr(at)gmail(dot)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 “transactionally safe”.

> 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?

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2026-05-14 21:35:46 Re: Pgbouncer
Previous Message Adrian Klaver 2026-05-14 20:11:45 Re: Alter the datatype on all tables present in the database (bigint to varchar)