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 1w7qX9-005kjc-38 for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 08:02:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7qX8-00FwHx-1R for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 08:02:38 +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 1w7qX8-00FwHi-0W for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 08:02:38 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7qX3-000000026aM-15nO for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 08:02:37 +0000 Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-2ad9f316d68so29121055ad.2 for ; Wed, 01 Apr 2026 01:02:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775030552; x=1775635352; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=NhHM7VeHILF6dQhlrUr0VlLMyTe3V8X7CTAFiPfL6Tc=; b=KkvdmZQzmXsLQeCCJsCYcWW6GZU2X8z/2cgvbcrm9KjmFvKGpCnaQZLkp4tW/Q6neh hOV7nj0clJDyokNuua/rwaKqlSPu39X6OC54G2GnIoI3FCros0hBj1hviBAoSFLKueE9 lvCl2utXX1B9J2xlfQ0WkvUXGmsIS1qvpqUOjJ0gsBFgj71yAio+2GMwgMcum22Jdmtx sHt7UFLaJP3R1yxte33CuA27VnaETnEyH8a+DWoncBZl54NWuWIJ6Dqq4rOm63cy/WAi csT8nz91+zZIQXs4rGXeoqHJ5rpRTAdianjleu1EMfdlgrAbhgrVcBtmkhbt/8CJD6c9 +/cg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775030552; x=1775635352; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=NhHM7VeHILF6dQhlrUr0VlLMyTe3V8X7CTAFiPfL6Tc=; b=cnQytqXcID8qZxVW+J/1HuwEqb/dSi22ZH2Zb23/NwFj2pKDtPju90+MntAqunLoAx oZ0JiIyIKIo5I9IRv9fY0+JpzQsYgikwU8AacXTmDjUlWf2mMuQxk3f7B2EklaXG4t9Y P0gGD3VzJqHxmp/zCuCG8ODPcJp8vtiRvN6iXrgjCiQJ6YaNA65+HRws+8Z+i/j9b1x0 IuiVo7smlPNPCSFiK1YO2ZDbeL2msf3Jt9+C7pRvskEuzcd1TWgDUCtXpgpwOtjHxLjw jbqJR11n8pdg2sDWqzGq9s3kYFLcGusHeGeQsV2lXnNdof95r+gusYHyPhQRsv69HjhI UdHQ== X-Gm-Message-State: AOJu0YxcbRXaD+Jfj13VWqkQN5GEPNcktJ2pUINB027sxJvnoYQLgo4y z72M8i9DEHq7T5bYvAc7K4dasQLxCYdIh6tTts3BuTULt8kDY4rt24yxm2MhY7eW8gc= X-Gm-Gg: ATEYQzyj6VIOHWciqEsnN462JjBGIeTvB0uJNLnZ+8VuTAZ/PG9c2fMNximnE2FSKt9 47m33DAAb7uNTyUBEmKKaahN1wOzVM4ts0kNJQtrxytvccJglZOD6si34Of45LDeDn0FUMvZQcG /Oxcb51XFUhvNcd3QRvxUMH/+jHq+OGC0Xg3ZjPIlwvvMsVsC5PsPW+ubTDgkNFche5J7YeQPby KFLsptzVpJVkA6lOtDxRL+gYINcVAHKRRSCcOVb/gOJ+XpYMRdLBlqWcqmBI1xDDwEJKV++l/2J oI/Nbl7DTkWFxvZLA40vbwEdWMGdfIRY+aWGCQ4q8aEw10BIUsWMWEXcRORQhUMLGfgErcdYZT/ tZwZRDj510AiyFVEcCMTC/sOkp9AIrbFxCZIqQCZldmDd208pvdHg97/TPrHRL4xo97oZHRJHx3 k46Ffa3vwZifruX5k+pjPUREoeq8Bvp7hY X-Received: by 2002:a17:902:ce03:b0:2ae:a45b:42f7 with SMTP id d9443c01a7336-2b269c87fb6mr24303755ad.36.1775030551729; Wed, 01 Apr 2026 01:02:31 -0700 (PDT) Received: from smtpclient.apple ([185.135.79.125]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2b242765bf4sm165911025ad.42.2026.04.01.01.02.29 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 01 Apr 2026 01:02:31 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.400.21\)) Subject: Re: ALTER TABLE: warn when actions do not recurse to partitions From: Chao Li In-Reply-To: <8D28407D-A48B-42F4-88C9-A1EE182898F3@gmail.com> Date: Wed, 1 Apr 2026 16:01:56 +0800 Cc: Greg Sabino Mullane , Jim Jones , "David G. Johnston" , Zsolt Parragi Content-Transfer-Encoding: quoted-printable Message-Id: <74084E4E-4763-4A23-9886-FEB4DF67859B@gmail.com> References: <6eff5e43-cacd-4a2a-ad1d-e3b313c86050@uni-muenster.de> <950BB7B5-0180-4C36-82A0-7E17B920F740@gmail.com> <8ECD9403-F0BB-4971-94CF-2709EEB4E3B9@gmail.com> <9174F0CF-2F70-4B4F-AED4-CAF113B7F093@gmail.com> <14669a83-c7b4-4cdf-890c-dceecd025ee1@uni-muenster.de> <3F59D90E-9A47-4C1C-B330-D62D668A462E@gmail.com> <5e01263a-1994-44d5-9e98-7212acf9c985@uni-muenster.de> <8DB1987E-08F3-46EE-B440-A1358310486B@gmail.com> <8D28407D-A48B-42F4-88C9-A1EE182898F3@gmail.com> To: Postgres hackers X-Mailer: Apple Mail (2.3864.400.21) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Mar 13, 2026, at 11:16, Chao Li wrote: >=20 >=20 >=20 >> On Mar 13, 2026, at 05:45, Zsolt Parragi = wrote: >>=20 >> Hello >>=20 >>> Affected sub-commands include: >>> ... >>=20 >> Shouldn't SET ACCESS METHOD be included in this list? >>=20 >> It only changes the catalog entry for the parent, existing partitions >> stay as-is. It only sets the access method for future direct child >> partitions. >=20 > Good catch. I missed SET ACCESS METHOD. Thanks a lot. >=20 > PFA v9: > * Included SET ACCESS METHOD > * Added a new test case where if the sub-command fails, then the = notice message should not show up >=20 > Best regards, > -- > Chao Li (Evan) > HighGo Software Co., Ltd. > https://www.highgo.com/ >=20 >=20 >=20 >=20 > PFA v10 - fixed a test failure. Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/