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 1w7osT-005izd-0c for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 06:16: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 1w7osP-00F80I-39 for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 06:16:30 +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 1w7osP-00F80A-1z for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 06:16:30 +0000 Received: from mail-qv1-xf31.google.com ([2607:f8b0:4864:20::f31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7osN-000000025nZ-3oS9 for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 06:16:28 +0000 Received: by mail-qv1-xf31.google.com with SMTP id 6a1803df08f44-89cc71f4311so77290406d6.3 for ; Tue, 31 Mar 2026 23:16:27 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775024187; cv=none; d=google.com; s=arc-20240605; b=Agjh5Vg9THcR4BigO8MCMIIE1TjMiUix9OKiFsPbsh+0/YntWkiLgGCZ6jD5S4Zb+9 /3IKeg2bsxc4kDmm4e2N2E23Z/5gKvyPcr48s7ANGV+Va6YVQDieC75W/7sN4LenF5xM 7aSPwOWnVlQspKzbQWBpumayhrCMIZ56wPwDLbi/WnVlLGBO/O4aQTUaaDy96eOoUAT4 vo3yfIYkPSle+DV6vCac+Kuxg9ungoRHURHz6uFvJFHDF1NivpV6UqcDF7FnYVvNFSXt e5QKiQnssAMyPZpqdmxYNSITA0n9o9OKqoMEUhqFhe/FCZHHdsM7ZDNst1UlDzyNvwMp 8Yvw== 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=E5+dxGV4qhfdC5lyvTvyIgWkRSG5BbK0U9iBURNjrV8=; fh=dxJXJbLzq9Nah1LUdsj4QTuQ3JoDScd0wp1YHY64NXM=; b=Wel9aY4K+857J/+oceck8QQNodYFn2pjs8Wb6wp+ARJTAGeTw7STIvQTedis0nYT7A 0+TPBFenu+N0K3mfzN8cycp9jUkv+1j9Kc+Igo79iWZR1nKcuO4LAmxgf5R2thAbvvTo 2hZEfCEMCBkdeeN9YxS7H2Nu2hvypnKPTpIdfYtBiM2rEHO5RjU29XX/k+94T3rdCkBM AqHdOAh1Ai0oyLAPAxhq9L/jZ43TQkOECJJ4JlYULQZcfcbcODOHIScyp1OTSDZNOXS7 l5VSzzGoedvLuSO/cvRJPVE+9J6wQCIRGvCoLIZw/N27auGrhfOINND0W42g9U3oDvuQ rQFg==; 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=1775024187; x=1775628987; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=E5+dxGV4qhfdC5lyvTvyIgWkRSG5BbK0U9iBURNjrV8=; b=r49mZroN5HutQslxPNmfLCLZRmuKemCz+XS5mVksua7p1nc+q56vIG4lVGv21129TW ohmQyvU3rNCBdbjHQnpjiAiRu2MKeKxIzk3XxY+0yX1bQ6Ee/KB1jIyKAg1C/tqnasBS qROJdTTyMP43ELuOVPNju3Qn20u3i08yisl/7zqEEJZjVcWHYzrE+dHt4x1S1Qkim/YH f5h0sCCRZRUSD4dTNfV0JrMW5TfXFURpC0bA9moOMy8OpoEjlHa5SnBDxkwjw5vSwyLr vwjF6OmHWPNWvaLQBC4EkPEBYzrCeWQ4RKbjs5bjeG0sTw7b3aDpimarefCzYTLA8y7o sLcg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775024187; x=1775628987; 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=E5+dxGV4qhfdC5lyvTvyIgWkRSG5BbK0U9iBURNjrV8=; b=J22L+M6G4vIG4R8C1PD2zzNjiPRl1kq0PwCDtesXSORfUE+8ReNxinUD/8S4hy7hfk swVd3p5yye2UUVKG0uQYIDRsR1xYdgdmWyrJXMy+scJKnolGXuP+F7RD5WmZbbu7626S dfkKILab+ARf5GWKb9ja4H3H3VaMiGombDkkKjSpwOV2Y381jqn3+xMWYn6+ySt/Iuop XPHp1ID/UOSXbhHVCYE44WcDlttpLdZRJBoRunXibg8K3v0bs6KUkxLf7zYTiHtTX1IS 9PZkQqHHQJooXzGvoMH33zhTaNJ2jfq85/UNwopGoGvpRWSSND/9CZ+J4hc/s//Sat2d MVgQ== X-Gm-Message-State: AOJu0YwSC7qUwfKhAX2nSvW9OBpS9ybjIL7jzbwJUaP8tlYPdMw2xrdt gnw1AV41anogmaAr0blf4c6XHJnDNwUR9Bci2nLSOchcMsIKgu1BZpAEcHGjCwWl70pJsglc4A6 n5MNbE/jj2EC6SuEwW3tk8mix9okRrsBIPNOU X-Gm-Gg: ATEYQzx8Z8SXAfLencLlmWYR1gz5m6F9r64DYWgdMkXJ4tjYorzg+S5nXQw7Wfu2K4t roraNeQJPm97I4WXqdc0pHTuR7x4zxK/nm2EwwvvriZSwb4viCGcxcWVESUzA/cQv42naAkBkBN AkOSCpRzxtKpQxZY84ecbKjUaFo3mPjB9Vm+c2GBnzZiB8zf+GS75TvVaU4ictrO14bb4BD6h4m 5I0ZmV5v8NxqT9hKVm0rhchd0R3bS+7CxO41aFyvQusRVTyPqMxkf0zSxA7YP1kERNj4M4Ubsmv qft0YAEIj1o5x45aY8Kh32w+wqZN+crBpsmHxoPGOQ== X-Received: by 2002:a05:6214:5e02:b0:89f:97cc:b8d5 with SMTP id 6a1803df08f44-8a43761a46fmr32907306d6.9.1775024186087; Tue, 31 Mar 2026 23:16:26 -0700 (PDT) MIME-Version: 1.0 From: Peter Smith Date: Wed, 1 Apr 2026 17:16:00 +1100 X-Gm-Features: AQROBzBPGGMV535COll2XwXLguUXc8kDs5WyWZZq0yWiCUuDqLmtoLXubIH_ShI Message-ID: Subject: DOCS - DROP SUBSCRIPTION does not document parameter "IF EXISTS" To: PostgreSQL Hackers Content-Type: multipart/mixed; boundary="00000000000014fe6a064e6006cb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000014fe6a064e6006cb Content-Type: text/plain; charset="UTF-8" Hi. I happened to notice that the "DROP PUBLICATION IF EXISTS" parameter is documented [1] ------ IF EXISTS Do not throw an error if the publication does not exist. A notice is issued in this case. ------ But, the equivalent "DROP SUBSCRIPTION IF EXISTS" parameter description is missing [2]. ~~~ PSA a patch to add similar documentation for DROP SUBSCRIPTION IF EXISTS. ====== [1] https://www.postgresql.org/docs/devel/sql-droppublication.html [2] https://www.postgresql.org/docs/devel/sql-dropsubscription.html Kind Regards, Peter Smith. Fujitsu Australia --00000000000014fe6a064e6006cb Content-Type: application/octet-stream; name="v1-0001-DOCS-Add-missing-description-for-DROP-SUBSCRIPTIO.patch" Content-Disposition: attachment; filename="v1-0001-DOCS-Add-missing-description-for-DROP-SUBSCRIPTIO.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mnfniaqh0 RnJvbSA3NmI3Y2Q5YTdhNzBkMWRiMzI1MDRlYjdmMTJjYTkxZWE5YTIxZGZjIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBTbWl0aCA8cGV0ZXIuYi5zbWl0aEBmdWppdHN1LmNv bT4KRGF0ZTogV2VkLCAxIEFwciAyMDI2IDE3OjEwOjM3ICsxMTAwClN1YmplY3Q6IFtQQVRDSCB2 MV0gRE9DUyAtIEFkZCBtaXNzaW5nIGRlc2NyaXB0aW9uIGZvciBEUk9QIFNVQlNDUklQVElPTiBJ RgogRVhJU1RTCgotLS0KIGRvYy9zcmMvc2dtbC9yZWYvZHJvcF9zdWJzY3JpcHRpb24uc2dtbCB8 IDEwICsrKysrKysrKysKIDEgZmlsZSBjaGFuZ2VkLCAxMCBpbnNlcnRpb25zKCspCgpkaWZmIC0t Z2l0IGEvZG9jL3NyYy9zZ21sL3JlZi9kcm9wX3N1YnNjcmlwdGlvbi5zZ21sIGIvZG9jL3NyYy9z Z21sL3JlZi9kcm9wX3N1YnNjcmlwdGlvbi5zZ21sCmluZGV4IGQ0ZjU0YzcxNzBlLi42ZTg0YmIw YTI1NiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9kcm9wX3N1YnNjcmlwdGlvbi5zZ21s CisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvZHJvcF9zdWJzY3JpcHRpb24uc2dtbApAQCAtNDksNiAr NDksMTYgQEAgRFJPUCBTVUJTQ1JJUFRJT04gWyBJRiBFWElTVFMgXSA8cmVwbGFjZWFibGUgY2xh c3M9InBhcmFtZXRlciI+bmFtZTwvcmVwbGFjZWFibGUKICAgPHRpdGxlPlBhcmFtZXRlcnM8L3Rp dGxlPgogCiAgIDx2YXJpYWJsZWxpc3Q+CisgICA8dmFybGlzdGVudHJ5PgorICAgIDx0ZXJtPjxs aXRlcmFsPklGIEVYSVNUUzwvbGl0ZXJhbD48L3Rlcm0+CisgICAgPGxpc3RpdGVtPgorICAgICA8 cGFyYT4KKyAgICAgIERvIG5vdCB0aHJvdyBhbiBlcnJvciBpZiB0aGUgc3Vic2NyaXB0aW9uIGRv ZXMgbm90IGV4aXN0LiBBIG5vdGljZSBpcworICAgICAgaXNzdWVkIGluIHRoaXMgY2FzZS4KKyAg ICAgPC9wYXJhPgorICAgIDwvbGlzdGl0ZW0+CisgICA8L3Zhcmxpc3RlbnRyeT4KKwogICAgPHZh cmxpc3RlbnRyeT4KICAgICA8dGVybT48cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bmFt ZTwvcmVwbGFjZWFibGU+PC90ZXJtPgogICAgIDxsaXN0aXRlbT4KLS0gCjIuNDcuMwoK --00000000000014fe6a064e6006cb--