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 1w74Su-004vqe-2V for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 04:43:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w74St-001F1e-0M for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 04:43:03 +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 1w74Ss-001F1W-2f for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 04:43:03 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w74Sr-00000001kWi-2WMx for pgsql-hackers@postgresql.org; Mon, 30 Mar 2026 04:43:02 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-5a1307438ddso4307051e87.1 for ; Sun, 29 Mar 2026 21:43:01 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774845780; cv=none; d=google.com; s=arc-20240605; b=cGN2tOsVZtSj2aSnbVvP0GGAfKPCWyygraIZXeJPsnFHjfT1WhjrmrjZkALaRbjpmk tbdMKXoXagRwtht1QRUST67YAdJTjn9kTemomvSMTp+ZHB+4377Qd+ICF/0jqD1p5PyN E/pOSlmZURHfXwVVUkOfChW62wsU9YALvkvJRoy1TaHZ9Ipa9OdVGU0/p8gACal/SDUT 8nSmmZH6E90YCiemwAQ5TGp0JZzw/Q/oH+Kk8S+W/MgIQfJDfcX68QJiVGtBgQKRFIKz VPWgE48YT5TXdO/dHUVHYXRCRey1iUEy7vFNi8fVbt+04VTq1Z6ebrjSt4w5uhDCBeYG ETiQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=wr1WyIXhtpyJWbJ2WiARUie+OxzPz7Kyg2LhwIZOaDY=; fh=igcEGMHnoBhnTc6MSHEWA+fLH8GXLbH0KqSAs/PhC6I=; b=BcCU7XRcL2NS93iCQLDWeppvs9jYJgEKkRehMU9KY2OhH3m7bKIVBTvsyfGsU91fpk BuoW4NorxF2Zm2EvyZDwynbw1ZwSqagj2a77HGrqKA5YA1XUbT3aB4BXBe4ZWcoW7gkQ SD677ZOm0o5Mg+aY5D5o5bXfWH9FEwtSZAmxJifZWlYDaAW4xhp2GwYdQwChfXDArFcZ oUV9Gda91rJFS8KAvmbY57XwMLKp8u0eyzvOgOgVd9Smyy0fJmDJuBCyvcshQZjBTJ8J W0tSNm3KnSEyOsbApkxrG0zf+INf/kzkVLWwqjljL9BNcxLeSMXWj0auzif2g72U/wj2 /dDQ==; darn=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=1774845780; x=1775450580; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=wr1WyIXhtpyJWbJ2WiARUie+OxzPz7Kyg2LhwIZOaDY=; b=CBAI9qVJeaXNowHzvKCTMy3aoeVoniRxPcxZRa10I9v1oq6UzAsh/9DHpzkwL74XbJ MFYcnYN10zZhYQjkXwcl9BdzKo87K7DdBxzNZ67iSjDcHCPmP274Mz5Ywc2Zo5fvsdKd zzZ6diA0SQ4tAg4OiBpYNTIG/i4JMqGuzh+2C1n+0xcqiN6BSZu3gseqFp17mhG3G/tr bItYPjmlSILMnXQ1l2M50XVieNUeOTKutvlsG5cEIRO929SULHIJeWAN8cVkh7/dikr0 T9NOugbXPJrS4emv3GvThoYzU5Hvn4Y6xngSIKZKie/DinBkaVAmmS8aTV8B05ugor3s cdew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774845780; x=1775450580; h=content-transfer-encoding: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=wr1WyIXhtpyJWbJ2WiARUie+OxzPz7Kyg2LhwIZOaDY=; b=ogZHAvKgFCRoO/oRbDecrVT18zGoTM+GW7CQ9kO0+/0ZYjMN97ZG47wjFD2Et8MWSe Tuaj+llTTFyJJYyAwzImbhOFBEPpQhHpWxxpJnQqD+QVkmJPUhqVgmvzhddDMe19sv6u gGe022Gc6q0XpzEHCQWl6hTmlKPJgADpjTDNdHKBEOh/w5AmUKdcSKoCJWuU0z3T8Rcj 9TKBQoQzs0GG3K0KwBhmFy0hmkcJcsxQZmX4R11sOsZtkn5lLlXmSYPb9vEgfzX2icfO DebFxrJwiekE9CaZf4Eq5udUPGO44OLpviUJ3J4uMJvhs7isuXCLofM7ZW/TH5U3mXn6 E67Q== X-Forwarded-Encrypted: i=1; AJvYcCVvd3QbnyO697DceEqcmftG5wnpnBCo4E2pFWHn/2PHkhU1xNoQmvk8kobONWJ+9SHtn8yqL36hMU3W/82P@postgresql.org X-Gm-Message-State: AOJu0YzuGATDplTR9fdyZbl7CnHA/E70OxPQWYO4RhAnIy+Zle675Mxc lrkyzte3ZK4EJc3YnzcPgugIq7Obcb7A5r4WhaWDieSEkZx0SFyHWA4+ihIea6Bmk6nWF7q0MzE kt9YSSsnMOzi7VseaG3myVjkRL8HghmU= X-Gm-Gg: ATEYQzxPfEABIx1HoXWLSwzfUTScmvjhhVvnVFxIQ8rk0cBiTb42JSvyr7DDqKjmXMb G4ofo/tE8Agf33LqcM6+hkSdoQcnpV/ZKEkpjBT33jWb3NctSudyBo8bM5kCbnspx451B39mkDq w81GhRP4xJoFgVtanlfh/HDn40INvjt4m5mw2SMDfqAUMaPIHYvHTeX10SAeeBvxEg3uV1OP7ql 7u/KdtyxQXhIqK98oWv2S6tWTB/VgAEAov3Fm4rLZb3Tt23a7y9ZgcKciesypGN+m4tLzKGWyw3 /M5I5cpMFw== X-Received: by 2002:a05:6512:124b:b0:5a2:b219:3ecb with SMTP id 2adb3069b0e04-5a2b2193f52mr1785038e87.42.1774845779745; Sun, 29 Mar 2026 21:42:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ajin Cherian Date: Mon, 30 Mar 2026 15:42:48 +1100 X-Gm-Features: AQROBzAyYBTNmVJ-J17wsFwOvz2PlB2K_1NjPNQqyo0pxCPhixZGxEMg844Lfeo Message-ID: Subject: Re: pg_publication_tables: return NULL attnames when no column list is specified To: Roberto Mello Cc: Peter Smith , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Mar 28, 2026 at 6:54=E2=80=AFAM Roberto Mello wrote: > > On Fri, Mar 27, 2026 at 11:27=E2=80=AFAM Roberto Mello wrote: >> >> On Thu, Mar 26, 2026 at 10:07=E2=80=AFPM Ajin Cherian wrote: >>> >>> >>> One observation from reviewing the patch: the test suite covers the >>> partial column list and dropped column cases well, but is missing a >>> test for the two-publication conflict scenario (one pub with no list + >>> one pub with an explicit list of all columns on the same table). That >>> is the breaking change called out in the original report and probably >>> deserves its own regression test with a comment explaining the >>> expected behavior change for users in that configuration. >>> Patch LGTM otherwise. >> >> >> Good point. I know I worked on that, so I must have accidentally dropped= it from the patch. >> >> Will prepare a revision and submit. > > > Here's v3 of the patch with the missing test. LGTM regards, Ajin Cherian Fujitsu Australia