Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wNdZK-000xH4-1R for pgsql-admin@arkaria.postgresql.org; Thu, 14 May 2026 21:26:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wNdZJ-00F6LQ-0y for pgsql-admin@arkaria.postgresql.org; Thu, 14 May 2026 21:26:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wNdZI-00F6LH-2r for pgsql-admin@lists.postgresql.org; Thu, 14 May 2026 21:26:08 +0000 Received: from mail-yx1-xb12e.google.com ([2607:f8b0:4864:20::b12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wNdZH-00000000bH8-1NhG for pgsql-admin@lists.postgresql.org; Thu, 14 May 2026 21:26:08 +0000 Received: by mail-yx1-xb12e.google.com with SMTP id 956f58d0204a3-65c7492a2ceso9371431d50.3 for ; Thu, 14 May 2026 14:26:07 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1778793966; cv=none; d=google.com; s=arc-20240605; b=ElZ0vj5yAsf3QfJPdrvA+PWux2jfs2F6IOutfNWk4GRzsikz5tM01C8pm640Q17KvH k9LjznsE1xe0SRzuZhahDLL5rBpfpurf88M8/hI9UGnmWUJZ6ZxojwsfTfpqFPwxFnht GRIL55IzbvSVUi7sGgT5IeLYtfW1izb5LYigZKO47LgCoyjAUj5rSYTUEzNe2n7ueSNE gIaVRUVun0ci5BQSOJe16sbFl/Gzu0h0kQ4WPVDVUv1QRZUtSCNcr6hBaU8Ys6LOXxjf G2YJj2wYLwweeqDIJ5jgbLXlwDSDDKAoIFXyKSyGxVq6gMLaiWOkVLRgflhsWEHuPbzp /CQw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=pvmQuhdPIj9Hdr3s3wcgaihW4eZnZ/bcktCnjKj4Gag=; fh=YVqAsyQLaqkSOJ1zvqJdlUnoB6bSkwHNHq4/MX0Vk/s=; b=IQdEvkao07bFyg5lKom5MU08RY/v0b7qa/Jj1+kffGHWpb8aB4Djw74xoTVTYP5gp6 r4kR9YqVy1i3UZWFz7MTECUCICXKFRqH+a7WyebViE0QC38d6a4wAEOeXwdynkbu4XNI Ydt9Ya2X5EKeIRrPQXAUMbf9LDZLahxrOC9Vyk3SMsvUTfFQrri80vnUNnHIy5LJq3J3 4piTbThdezNFxDOvSc887XISa5KOhnMTtOz0n+n0EfcgWGOGi8SttwqbHm9R/72DuHuf cbsj8IKJIIaTjsGTaLaqrY/s+ZmlLHiM6nISZqzEWCPtCCG4jqBVbq7KZsAE9a0SDeiv QNAg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1778793966; x=1779398766; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=pvmQuhdPIj9Hdr3s3wcgaihW4eZnZ/bcktCnjKj4Gag=; b=ckfEVjzpHy7+w7oU37tP1smmd83UlddLV28/f01InMvXxliZOM1xQhU2Mk7t5HAo+P I3s2P8shU2woEx56Ks364i+HvL/Lf4LIFTWKcGSAp9H8yKDgF480Ij9x7SVLtv/eQ/Fy Seqeeh26GusTXdaoasSV7TlRSEJNQtyY6VIKoIx71qU7KE0gwJqjs4x9T4QVeI71mwE1 1GJpHp9HX7LmrJCCndrdn5ryzGuQyrPVKRvBl/EY0dMyvJOkPjE98NXUBcb2f1t1rXGf puorXMDZKpr4KVI1L/7Ln1Gy8KFE666yR0PUulafy3wI/UDJNExvkOUZtNFD3MO5w5Er m5SA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1778793966; x=1779398766; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=pvmQuhdPIj9Hdr3s3wcgaihW4eZnZ/bcktCnjKj4Gag=; b=YslZpnNjQ/d5sesOph8JSFfw1cNEnFLuzXZwjzyW+oxv3zxCeIT1vN4vQfofFntT6U XnaGK5JjEu+WOLbWVCYvOPON+bZOCpofexQ+gR1rrPXTT/DiSMm3eXRONvMtLUOJ8FAZ 3iiorzzF0QOXltaN801Mz8/3vVvsINPcMFaQ+sLgZQTTDvqDqSmefwMfqxGH6L7F6pFV ncB/V7oVdDG1fYkNlq8bc3s13O4oL5da/SUEhTdZxzTwZrigcp3nhMa6lzrx63iEH8qh xYQK654nqWVkxyIz+tUoYY6oM4uBtISpfLIIGzlkB5JjMGFjsrvLCLL7wD32lzL84gzg N3qQ== X-Gm-Message-State: AOJu0YxFiSqLUCmWD1yUc7bBfP0mKPhAwaGOyTmdQfVRWq9YpI189KTl stVaXRRkJj12LFaIpHSg6/yywwtZEFGMzk4gQrJIWAnd7ttIKF0oBr8kGt8Frf3fvFmvZW2pSvY KFykTvMr1x0S6PVFcT+OWPDrddW6hDbw= X-Gm-Gg: Acq92OFeHewENsXavdbfmP3Lwi4hCJpkLQijbIaO3hbkg2EYD+9Gj+hxF4PGLDtN7Lu xjWTVxzq8EYMdGv0de90EQ3gc33+AY2UAoUL1gLSJU2mg6v1RJT0ycllYg7mbmwQ15tgZjnFEwZ /MRMJ47rt7vYmtqvqUGy5/mVLTTmAcM3MN5SeN7+yK9DB9WgAWoIDg6pqB2KPLmfC5ze2bCUhOR y07P1GzdcRlpoYUsnSuegReurcDxeXcFUufeYCSvRQzLgc/OsIr2xUgeeEXCyMdNmHUJxG/YbZJ VbTV78hZBRTkAKj1gw== X-Received: by 2002:a05:690e:190f:b0:65c:4b93:4256 with SMTP id 956f58d0204a3-65e2267a472mr1128306d50.15.1778793966445; Thu, 14 May 2026 14:26:06 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:7010:1624:b0:515:4a59:a911 with HTTP; Thu, 14 May 2026 14:26:05 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Thu, 14 May 2026 14:26:05 -0700 X-Gm-Features: AVHnY4IyTkNI13IUMF406zp-A2YxcdZ8jzaviCHa45dhemMU-dbq8mo2lwhgOZ8 Message-ID: Subject: Re: Are these metadata ALTER TABLE commands transactionally safe? To: Ron Johnson Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000007fa9b60651cdbeec" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007fa9b60651cdbeec Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, May 14, 2026, Ron Johnson 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. > 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. --0000000000007fa9b60651cdbeec Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 OWNE= R TO foo;
COMMIT;


Define =E2=80=9Ctransact= ionally safe=E2=80=9D.
=C2=A0
I don't trust the validity of synthetic tests wh= en Prod is ill-behaved JDBC connections.


Then do them over a local connection using psql?

David J.

--0000000000007fa9b60651cdbeec--