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 1vfVJL-002MYD-2w for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 03:43:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vfVIK-002azH-0j for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Jan 2026 03:42:12 +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 1vfVIJ-002az8-32 for pgsql-hackers@lists.postgresql.org; Tue, 13 Jan 2026 03:42:12 +0000 Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vfVIH-0008FV-1s for pgsql-hackers@lists.postgresql.org; Tue, 13 Jan 2026 03:42:11 +0000 Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-3e3dac349easo5992253fac.2 for ; Mon, 12 Jan 2026 19:42:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1768275729; x=1768880529; 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=O6M3ClqDqoQD1eSlj5tlm/y/N4XA5EmWmF8WcLzPC/E=; b=jJ1u0KXR1wdr8Rv3mbS9vT/bod6ByEde6+c3tth1l3RgUy8g35F1cK1CcTa380Sa5D UesdkwLuH1phc1LzFKx1xK/k3JAjKyxSnJ7YDbUsXV8nl7BA7LE+WOdaqNOh2MTIBc9w SVF8y5s3/JjYH6CsS9Jo0VRyVkIf1TCvy9QW9d+KLxwvNUX1i5MwseQOYBRtLmOFdJKh 2H3TfUnQikBBbabpCuzrRZyLpLghMa/F+yDJPgQ7OKzzzxJPaQs7aDgQPDx8HM3In5lI jaGQ3EIrV+MsBn0AJGKM4Aerroukctwn/AzlIg2iGix/9a+x3TE7x9bwqxUslu9xxE2C Zgzg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768275729; x=1768880529; 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=O6M3ClqDqoQD1eSlj5tlm/y/N4XA5EmWmF8WcLzPC/E=; b=BtLaEnCNBdpAgMKZMBjOyOPonhApCNcJ78kWzuCI/iUWfquiuj+v0eF9FFqIzQki5S L3wvEXisRTv0aR/mkNeIvd5ODbUtXjLwjZfsM61Q/mREJ3/P9gvpbw/5bXfJc5NdySeC 9veftvdJcpr/nSC4Q71n5mlw8KXJQRpbL5Rbn6wWqo+8qrMPfz1vq09OnwTbZIda85LD BiPvKT3aD3hMPoqVz4suM5yWAjjsZV3QToIBLRUL4cv3M9e6cwWige20fqaTIfM+SZcH 12zRzEHgxpkzWjpv/4oQNieRWvf93cbEv/87Rya2uGUiAcfAqFGwjNiF02TWK8xl0l9+ oCJQ== X-Forwarded-Encrypted: i=1; AJvYcCVJnICexfssONzWTNFQ7w7OjdP3WzylZiAjzvrPxSGjpeVA/x6UodB3eJwIQ/id3NkUPZBErC687K0SFxtU@lists.postgresql.org X-Gm-Message-State: AOJu0YyU6K2xoxZSZxrMBco5Ubl8sODORZomlaXfAJ4zcIVa3c2Wn03u XHpPxDA8wZS1/ly3yGrLI7H1rR8Wtm6MGTbUIVqF2jVnW6YSlbzqTVJzFX5VPQdyv+IfkFsIuMM breXInQr5HGbxSNbBwkHY+zs+/TtkIAM= X-Gm-Gg: AY/fxX7UZhQ+YfGSH3nQ/GLZN4x1Pi1ZOmI21Hm9anmjyH5k++uA5Tui6zNKj/KK90f n6Ho4IKoyjVA77UixsGt3UreUKIA/apkO/2a3UoKVt3FEh6yRd9QkPNEdlpjlJ6r3TcFGPjrrkR c8Fh7aEsmu6/8qrJcmnwGSxWn4Exg7wBNM7AaBKbpOD476vUqFeXz2u45YVoVbTMb5rZoDaUE6w ntWLRLA4IACgdzyWjym4Q2gONegENfk8OqVp9Yzf/GrNlVoRqChquRXKuVGo8TJqpLXi8a0 X-Google-Smtp-Source: AGHT+IE/NdC4bxlV8+SrGRAYB6TE4msnLEYJC0WmwE56RsJ8HOclEhIqmyPS9FB9rHb1JPrhDLmbJG/s47sR2XHkYmE= X-Received: by 2002:a05:6870:2155:b0:2e8:f5d6:2247 with SMTP id 586e51a60fabf-3ffc0b8c925mr11169997fac.32.1768275729491; Mon, 12 Jan 2026 19:42:09 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:6649:10b0:619:571f:707d with HTTP; Mon, 12 Jan 2026 19:42:08 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Mon, 12 Jan 2026 20:42:08 -0700 X-Gm-Features: AZwV_QhmZ5CWowJNQNly5YSDw3PQVrGpIx-UFCNjJrRbqCAbdsUlRuarzwq91tQ Message-ID: Subject: Re: ALTER TABLE: warn when actions do not recurse to partitions To: Chao Li Cc: Greg Sabino Mullane , Postgres hackers Content-Type: multipart/alternative; boundary="000000000000b8ac3106483cc646" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b8ac3106483cc646 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, January 12, 2026, Chao Li wrote: > > Now, the message is like: > ``` > evantest=3D# alter table sensor_data replica identity full; > NOTICE: REPLICA IDENTITY does not apply to partitions (1 affected) > ALTER TABLE > If it doesn't recurse there should be no count. It would either always be 1, so not helpful, or if did show a partition count, beside the point. In the later case suppress the message if there are no partitions present. The statement =E2=80=9Cdoes not apply to partitions=E2=80=9D is also factua= lly wrong. One would just need to name the partition explicitly. NOTICE: present partitions not affected HINT: partitions may be modified individually using separate commands ALTER TABLE David J. --000000000000b8ac3106483cc646 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, January 12, 2026, Chao Li <li.evan.chao@gmail.com> wrote:

Now, the message is like:
```
<= div>
evantest=3D# alter table sensor_data replica identity full;
<= div>NOTICE: =C2=A0REPLICA IDENTITY does not apply to partitions (1 affected= )
ALTER TABLE

=

If it doesn't recurse there should be no coun= t.=C2=A0 It would either always be 1, so not helpful, or if did show a part= ition count, beside the point.=C2=A0 In the later case suppress the message= if there are no partitions present.

The statement= =E2=80=9Cdoes not apply to partitions=E2=80=9D is also factually wrong.=C2= =A0 One would just need to name the partition explicitly.

NOTICE: present partitions not affected
HINT: partitions = may be modified individually using separate commands
ALTER TABLE<= /div>

David J.

--000000000000b8ac3106483cc646--