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 1w0nqX-002Dis-1H for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 21:45:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0nqV-000RgU-2p for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 21:45:32 +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 1w0nqV-000RgM-1s for pgsql-hackers@lists.postgresql.org; Thu, 12 Mar 2026 21:45:32 +0000 Received: from mail-yx1-xb136.google.com ([2607:f8b0:4864:20::b136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0nqU-00000001pnb-0xwu for pgsql-hackers@lists.postgresql.org; Thu, 12 Mar 2026 21:45:31 +0000 Received: by mail-yx1-xb136.google.com with SMTP id 956f58d0204a3-64ad9fabd08so2028833d50.2 for ; Thu, 12 Mar 2026 14:45:30 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773351929; cv=none; d=google.com; s=arc-20240605; b=BKyE9SMsPJTIx1MzCOsi2eZnJBYyzwWkPvsGk34+m9YpWI5F9CbbXmvMkTJYz8kO2D qzpW7iBTz77mw/jo2PzflBixNp7p1ej1pLM3F/qatHFI8PadKUCDsW91W0sf1SUJ93EN q281GjjMOUahCpmYjESSzC/uudjKsc7JBA7KBppf926o32i/jCkkx/K1hqdM89JgDBKF he68aOj4gofBecmfOxcvNdByiDhinQYDycuWAKc9+jiV01Hcv0dMtcs277NHFrrRu/fa CENgFbeyHgawcSdIdH4upUDDKY17U03ijUeDi1aM7KFZIDVVP2XbUjnFZ2Gj6DWTRM1z u8ZQ== 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:in-reply-to:references :mime-version:dkim-signature; bh=R9hac3t08ziZIJE/gw+nMduTrRcLn/T6CTYMFFpoBtY=; fh=Lkt+dA+229u4QWETk5nX9jM1OcSSt3/W06bbYhZD6U8=; b=Ma2g4qtV8SsvlG94MiSnlr8INYdlzKXdYmKOZU8G40MeK65BsLSVhWnpcpb/XG5Sxh NpTHIGxtHtDsbTJvll+RY6U42MVaO+ccXzoNzcnQeE3f0RrffaANCT7uxKEWYLWe8VrG Ij0VW994SqCGAhG3u6XllECU5BTSxihx6ExjEVRrFrXTILzTZEfhBxks5YTwLBRYk7Iz +hv3QfhBXqiNsu7sY5soBUNhvwQKVGHgUi6btOFVCkWHVi9en2jz1dD9GUfNMrM1colg vnqzqa6r9sZ4+sYlz+uxxzSIdPIhIpz2mTyXMXpWJHTpNVrj39nqAS1cW4BnQm98iN5y LRKA==; 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=percona.com; s=google; t=1773351929; x=1773956729; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=R9hac3t08ziZIJE/gw+nMduTrRcLn/T6CTYMFFpoBtY=; b=LNkq7xyP/TOqr8vYhAc/DYVt5LcTnuFn4yf84fwJwmMtgnKg6SKGXaFdtwOlZbg8Xp 5sB7lcbOvcRndCEqtuw+ucnEJU8YHVhY4/JucyoXlq59SwxnGXLjopjENqecLbIT7/9s 5YtCmzDaWK0j8MchJZNyG2t5ertxQlFlarTaY= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773351929; x=1773956729; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=R9hac3t08ziZIJE/gw+nMduTrRcLn/T6CTYMFFpoBtY=; b=XKymhJTpeJBRso5H6FQKGKq80encWOgrxMPYY94OU3N4qTBqFVRPTQywKpvUoxf9Qg liSkPXdVEY+/ryYvpeqQcHMu7DleJhTX9oMUEfqAAlvj9S9U01dQjR7X01UgMdTkAZL4 +2EJ8sNnO48eFC4Tjb073evJa2xm028jZ2dj7CHEzoEp1auUZCG2+D6jMZHtWFfRXgBE kPsrQQI6gIF3RXbUjauxyqM+zt55G9XAnznq74UpJVXoIpeXIIR9jzvm58uZcaOSyL/u MsNQh+xmuYybpg4pplMDiH3vYEX8SCnFovEIuCVx12YDhiHsxR7Joor++BXdNHlrYHWe Ssag== X-Forwarded-Encrypted: i=1; AJvYcCX7q/MXrdjhS7vdmM7XoW8KXN20WH1pE5Z9Xmzn/L+WFyRiQx4Lsjj3HI8Gzo8vNuSw1JA9jb1a/DMqRpjy@lists.postgresql.org X-Gm-Message-State: AOJu0YxWYzGc1o5osmCYbcLqdRhTavfVo+Z08kLcE4H5uukgmvdm/GLe dfuKnh8UqIOCgMgu/ACZRO8M7zUfJGl6dgaqRuFe9ra57jdixybp4k/Mv+YqxwDOxS9s0qxByIb 2UtXbXx0BOUIhgHtPTGC/4Owa4XZzSHXltiL61PMdbz/y6PbEAne3Cg6VBWvlWm42pN5omyT9X5 ibG+hfAWl/s68va2qqwXywiVey1SJD35VJlbXIDrbqWMfa5ioEwbRUVBXlRpLqZSX5XErvmMYF+ EYndUKwhJetG7wYhzlF/NtpCDvg/ypZSzwLw5WxObEtMn+Ie9fhIMFkWpHlzZzVVcc= X-Gm-Gg: ATEYQzyE5MgZrs2AfCWeoZ/iVh4atpaXD8qOjRxE7BRZ8dadyBAI+HeevxU+mt0lk9i qytW2PNJ8d5vgbwNcXPWHNRYQW68dQrj6cLCoEzCrlAHC6O3fPxfGO7OMtijCx9LaFEPF/U2+28 bR2YovfOp9x2Y5rkhH8NSUYVP/FlHUvzI/rM2bOxFGqDsdDzEUmV3T7ejWL2I0XeKJsEpwczQFw SM+s+Mkhu2ihzpipaGyydTZlgKSS+xgdyiiRlf7ZEMeDhJYRzo7MzJCaZRKGfgXmZIJT6QL7Ku4 oCO7sAOukHttY5FHcFWhUz/ZWMYPs9DYrEi4YPt6dxmWmdIkMU/89tvLIS9G94SylHliggte5tr N8Io= X-Received: by 2002:a05:690c:d88:b0:796:2fde:5dfe with SMTP id 00721157ae682-79a1c18d08amr13344557b3.38.1773351929438; Thu, 12 Mar 2026 14:45:29 -0700 (PDT) MIME-Version: 1.0 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> In-Reply-To: <8DB1987E-08F3-46EE-B440-A1358310486B@gmail.com> From: Zsolt Parragi Date: Thu, 12 Mar 2026 21:45:20 +0000 X-Gm-Features: AaiRm53xwx4o0IZg0mGm-uqe1d3mM1PXbirg_mNzb4lWN4_cYFDs0ekYkUz1NIQ Message-ID: Subject: Re: ALTER TABLE: warn when actions do not recurse to partitions To: Chao Li Cc: Greg Sabino Mullane , Jim Jones , "David G. Johnston" , Postgres hackers Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello > Affected sub-commands include: > ... Shouldn't SET ACCESS METHOD be included in this list? 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.