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 1wDWZD-00348U-2d for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Apr 2026 23:56: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 1wDWZC-0076lc-29 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Apr 2026 23:56:14 +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 1wDWZC-0076lT-1C for pgsql-hackers@lists.postgresql.org; Thu, 16 Apr 2026 23:56:14 +0000 Received: from mail-qt1-x82e.google.com ([2607:f8b0:4864:20::82e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wDWZA-00000001O7C-14On for pgsql-hackers@lists.postgresql.org; Thu, 16 Apr 2026 23:56:13 +0000 Received: by mail-qt1-x82e.google.com with SMTP id d75a77b69052e-50d58c513dbso1079571cf.2 for ; Thu, 16 Apr 2026 16:56:12 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776383771; cv=none; d=google.com; s=arc-20240605; b=WeCMZtmcJ3qSm21fzbP+h2RwN4H5wsdFoaRV70lZQlcXzRXcGFrDl/LU7r5Xcq6znK EO6r6Y7Xk4vxxEI7skcywyLTNbBtS6jTwDsYIx4ML2aegvwQJa/h6K6YwUICUZrYnK5i PYHShCzyi1AWXPIaJE3gixRaPW2/PWdoYcMWQaUGDV0ie/8SiR3h/KwOCDHuQJKKXUHJ TugLz6j7fISvhE+xDPr+3SEvjSpQSC7DlvAbdLaCNP0zY5qVfnbK1lFCYCnsGvwEVckD z4FFoihhVqffui05sKp1jBtxDpX0QPIsA+eb+FjZLO+BwNqzpJbyCrWi6iBTgxe0iN/z e1yg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=Eb2IBUMb+XymkvZH8kOKS/qYNJhLhmMq3Ax4ftRTm/s=; fh=dxJXJbLzq9Nah1LUdsj4QTuQ3JoDScd0wp1YHY64NXM=; b=D70cHpuFrk8Wy2jde/88gikYdQs7NWvL7AHun3C48ox+KEKdJGxhIKpRARha74hS7n Gde78Kf3S0A8GOrFfe9aq5vlrfxMzHvo+iMNBUNUt3LGNGueHX1sXLme+EiwM7/Pio8r uRvzKvYZqXODRCp57JPQha4OYs2f4i+VEuzM06/oiEwTu/ueAtpX1ggL85IcFZ0eBj3D gYIeZlzy7XWJLXRUmbnPfHZAOeKNIFTnOMwuLT6NW5Uy51oE7LnBxpvGKRucD5bGm+nP RbN5Ik09PCmM5I4RclDRNxlOwns6x3+hm1Ilj2UdIMjda4/JcDUe66xaQ0cZu3YTLrQA wrBA==; 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=1776383771; x=1776988571; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Eb2IBUMb+XymkvZH8kOKS/qYNJhLhmMq3Ax4ftRTm/s=; b=Y+en6kXrvlEcKgrBvDoeux+n1yywQKo3qnWxz4T4GeKBGX5QaaOcrmn/iuF1r531+/ oa0Ru7SyJElNIIntR8vau+mngWwfZLF1wtR1PTsjLck8wWfA1JxGvhlrhOdXtshiRVRx bvoGfo4Zd3b8UmKxsO4QZMZ9fqWG6cM17uRmgeMhWWwzB4ZP0bCT/X1ajUjrx8/KiIFc z7RDO4H8w4mXYjcyZ1oJQzQ76TrfLKiC7Nh2oEGBBype8nDe8lw+u0IG8NcGfIqJpSHj o41NgmnDXc5Nlt7ngViaeTXttpEZXJhcUCTSpbg4z/UayfoDMF+k6JINv8IkqAt4O44j FUaw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776383771; x=1776988571; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Eb2IBUMb+XymkvZH8kOKS/qYNJhLhmMq3Ax4ftRTm/s=; b=ZXZlgSx1TBoKOx7KmUQVncf/F/082k3YhMUl2pZlvlgA1gdEDw1mQuRXDvjLdV41Wt 5349McVEszC6Wj+xXqbraALZEZ5XfEm3SBiw2gi1uQpZeH0uiUB30HuUtlcHC0QvPy8T lOvUrHrR5ppO2qpR1roIUek529RtOfzbnrwOnwtLttKIzDwhYJvxH8wzlGWBO69LeOP+ 0ldW1vheCEozFFP2IcPlFgaJydRpY5dhncvmJeu63HvTk+7yQN0nFQB4XzvJikbZwki+ 1DERvf4vKMFXQGotamtr3MO74pbGVvAr1ydRgtDeQhbm1p8HJ2Hd5thbfm8Vd2/TEsE7 sRhg== X-Gm-Message-State: AOJu0Yw9p4DkrvPsuoDy5WV4cuvOyyEHMnR7niYaI7f8soglKN0gShhk Hj+8+edQhQ12Ck8Nhx0gQWIJrYHq2LoDRzavM3YLv7nXcGFgJEIU/IVC6PvBiZBVZz/caPavOos x42XGjPVMXuqxiwRLd9R3UG9aZMCzHwayqeLE X-Gm-Gg: AeBDiesNOposn1/l1/NO45gqMOz6YsK/1uhhncwVSdQShhPuBZiNEwkNIOLwliSF/B7 7L+DOuBN2G8pw47GPz6sgNmdR0N8XLHluNPIvzm/jyJfTxmD5T86QQD88t5BPgy/EoF9q5iA80p J9BveeVj+3P10R7EvwVtDulrCzE7Fq+i8xbJGaCukAu56qRByOjBKxes2TC51WXvGnUKVMBt74W uZkftdco0oRPQBdbD6/2Ci2TPjSVGVpUDbDelnflLvKg12tOEpjM+S8yikC9NzMAHtaxbTgHhGP PdyRdgS5BuYaf5Csng== X-Received: by 2002:a05:622a:1984:b0:50d:6d66:7271 with SMTP id d75a77b69052e-50e3669a003mr9366501cf.0.1776383771190; Thu, 16 Apr 2026 16:56:11 -0700 (PDT) MIME-Version: 1.0 From: Peter Smith Date: Fri, 17 Apr 2026 09:55:44 +1000 X-Gm-Features: AQROBzDQChIYSfe-rwlHQlo8JbVpmv0gXNzMPzBiFOity5SGkbm1n-ievkZVNa4 Message-ID: Subject: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY To: PostgreSQL Hackers Content-Type: multipart/mixed; boundary="000000000000ab17a1064f9c9345" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ab17a1064f9c9345 Content-Type: text/plain; charset="UTF-8" Hi, Currently, the EXCEPT (TABLE ...) part mentions how 'ONLY' and '*' work for inheritance tables, but how they have no effect for partitioned tables [1]. It seems we accidentally missed saying that these also have no effect for *regular* tables. PSA: a patch to clarify this. ====== [1] https://www.postgresql.org/docs/devel/sql-createpublication.html#SQL-CREATEPUBLICATION-PARAMS-FOR-EXCEPT-TABLE Kind Regards, Peter Smith. Fujitsu Australia --000000000000ab17a1064f9c9345 Content-Type: application/octet-stream; name="v1-0001-Fix-note-about-ONLY-to-mention-regular-tables-too.patch" Content-Disposition: attachment; filename="v1-0001-Fix-note-about-ONLY-to-mention-regular-tables-too.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mo24yk3e0 RnJvbSBmODNiYWVmZWM0OWRiMDljZWZjYmVhMGMxMGU2NjU1NDYwZTZiNTVkIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBTbWl0aCA8cGV0ZXIuYi5zbWl0aEBmdWppdHN1LmNv bT4KRGF0ZTogRnJpLCAxNyBBcHIgMjAyNiAwOTo0Nzo1NyArMTAwMApTdWJqZWN0OiBbUEFUQ0gg djFdIEZpeCBub3RlIGFib3V0IE9OTFkgdG8gbWVudGlvbiByZWd1bGFyIHRhYmxlcyB0b28KCi0t LQogZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfcHVibGljYXRpb24uc2dtbCB8IDggKysrKystLS0K IDEgZmlsZSBjaGFuZ2VkLCA1IGluc2VydGlvbnMoKyksIDMgZGVsZXRpb25zKC0pCgpkaWZmIC0t Z2l0IGEvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfcHVibGljYXRpb24uc2dtbCBiL2RvYy9zcmMv c2dtbC9yZWYvY3JlYXRlX3B1YmxpY2F0aW9uLnNnbWwKaW5kZXggMGFjNTc2ZDNmMTAuLmE5MjQ1 N2Y4YmYwIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV9wdWJsaWNhdGlvbi5z Z21sCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3B1YmxpY2F0aW9uLnNnbWwKQEAgLTIx MSw5ICsyMTEsMTEgQEAgQ1JFQVRFIFBVQkxJQ0FUSU9OIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFy YW1ldGVyIj5uYW1lPC9yZXBsYWNlYWJsZT4KICAgICAgPHBhcmE+CiAgICAgICBGb3IgcGFydGl0 aW9uZWQgdGFibGVzLCBvbmx5IHRoZSByb290IHBhcnRpdGlvbmVkIHRhYmxlIG1heSBiZSBzcGVj aWZpZWQKICAgICAgIGluIDxsaXRlcmFsPkVYQ0VQVDwvbGl0ZXJhbD4uIERvaW5nIHNvIGV4Y2x1 ZGVzIHRoZSByb290IHRhYmxlIGFuZAotICAgICAgYWxsIG9mIGl0cyBwYXJ0aXRpb25zIGZyb20g cmVwbGljYXRpb24uIFRoZSBvcHRpb25hbAotICAgICAgPGxpdGVyYWw+T05MWTwvbGl0ZXJhbD4g YW5kIDxsaXRlcmFsPio8L2xpdGVyYWw+IGhhcyBubyBlZmZlY3QgZm9yCi0gICAgICBwYXJ0aXRp b25lZCB0YWJsZXMuCisgICAgICBhbGwgb2YgaXRzIHBhcnRpdGlvbnMgZnJvbSByZXBsaWNhdGlv bi4KKyAgICAgPC9wYXJhPgorICAgICA8cGFyYT4KKyAgICAgIFRoZSBvcHRpb25hbCA8bGl0ZXJh bD5PTkxZPC9saXRlcmFsPiBhbmQgPGxpdGVyYWw+KjwvbGl0ZXJhbD4gaGF2ZSBubworICAgICAg ZWZmZWN0IGZvciByZWd1bGFyIG9yIHBhcnRpdGlvbmVkIHRhYmxlcy4KICAgICAgPC9wYXJhPgog ICAgICA8cGFyYT4KICAgICAgIFRoZXJlIGNhbiBiZSBhIGNhc2Ugd2hlcmUgYSBzdWJzY3JpcHRp b24gaW5jbHVkZXMgbXVsdGlwbGUgcHVibGljYXRpb25zLgotLSAKMi40Ny4zCgo= --000000000000ab17a1064f9c9345--