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 1w7wII-0003AV-0M for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 14:11:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7wIG-000Nd0-1v for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 14:11:41 +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 1w7wIG-000Ncs-10 for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 14:11:40 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7wIE-000000001KM-1M9r for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 14:11:39 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-7d8b2703f37so6366204a34.1 for ; Wed, 01 Apr 2026 07:11:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775052698; x=1775657498; darn=lists.postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=6PxD7XdMXX2MpVee9uziHk5A8vuZ7gHwglIgtIYn3RQ=; b=c1GblIvv1cq2rif3DcjWltZNALKEqFOdHHfnRg7ZDgSxxX4pq2esyExZ30uARFfLE1 Kd9qbBl+vavJOPqHlQBc43/P4BpaGNjQSnu2dchLvDaT1eUqsBzSPOI9zGs0wH8ZjAxC pXcZR5Uejmo6Pib1i7E3f51vOfrQCOh0O/XKclmCjEu6mxGwb6ze9w5hUDDqN06v/3oy PrT5YwLMKmrdkQn6jBvjFBTg9k+rasMKGSdQhkmK3yL3YGS5Ra14HfMVrs9SKx/nTtlz bSJ5VMKmyoUebkzbpsTWeo3PgvssTRDIcXUV6yFXBx6p3sMadWraW+ElWS+rjCzUbj29 WJOw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775052698; x=1775657498; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=6PxD7XdMXX2MpVee9uziHk5A8vuZ7gHwglIgtIYn3RQ=; b=BxTQaPLhevxAuyHlN5gwypBu0Q1SVxTGDJqTmnFqDkxo/t8FFmJNXtEMsl856DBFtk V58VQJj1FPAMcSMQkB2uIypEQAoLqOMPkpa2W4lSmkd4UiFDpsVze5/gxyDXfAw8s2Nk 5+EeVCH3e3yBX8nNAiBb9g1fy9sHPe8VZzyBGUVEi0/GFT+WGHYLAL/P0KSrgUuNCznX fmcl9MT7wCsAVZKy0+5pOGLS3brKehLPh3Cmnelvi3CLIsVfA6hF1oQwYm0ne0yYqiYb WSu00VrNNUSQzSFlb7zhaCEIMLCrC1d7kVM7VBS+mgO11t0YQGQ3M25SBeoNuV/E/6WV Y/Qw== X-Forwarded-Encrypted: i=1; AJvYcCWdrMWaJnQgKOyVCPMdEBfkJcGYU+PIYFjLiKY693/SMvB7ae8j58w9GXVaKbh5yVsIT3l8tjfYT3q8B/Td@lists.postgresql.org X-Gm-Message-State: AOJu0YxQR5LSBshEfbE9uUdst8kk022Acx8xPqIyKzX5N8szcbKg1IP+ opFQMWL/RJignMEWOKaXNHnQrDubjSAkQek/qUKWFia6ORIOdGICGv8c X-Gm-Gg: ATEYQzzem/AAjJ0e6J/Ai6Ko6mktXXkwxFKZ/mgu7gZSE4bhSSnPkKOl2XxI3+KWoMP k/bNw6U2KfPhUPAVdgFMn4PkZtDBuEGhzc56dCkBYTrLp/wIPj1rcwJOgPI99j4saVCoiMCMCb7 YwpOJYHg1fTXGv4yg7PFoBBrN8dxitAXVXh2rAVj4zA8r+tqPUTpvGZhxPqws0ewavSWm6x1LHG UVbBRgHwBWMCS189+W1NNcw6XvqeKOASWFJ5C2NZPoZw129/ezkoOgVTEwE8+mnEwMiy18BfESI m0cPMGacMFjFqwlO8QOKM2xalUtvLcibet0r26Evok8aFJRHdfavyLj2yMMPwqXsBJSuwOWIUCT IDZmLlpCAv31wGawMchVVEJdN9Mcw/Q6NCuKj6oy/GI7PrnAXGXmUXel7QoZAEE7fZtHgrMUVlq EmHzL/SlEE0RJ9K2IxHRHjeZSNhTJvjlcFnw1QISyVdS8+TClmcocAdqoiOiGQgyq5zJ1Sc9VWs bDSv+I/sQQbk1xNpFzkKw== X-Received: by 2002:a05:6830:210f:b0:7d9:d530:f1e8 with SMTP id 46e09a7af769-7db99400a7bmr2291358a34.26.1775052697782; Wed, 01 Apr 2026 07:11:37 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7da0a335421sm10413498a34.3.2026.04.01.07.11.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 01 Apr 2026 07:11:36 -0700 (PDT) Date: Wed, 1 Apr 2026 09:11:35 -0500 From: Nathan Bossart To: Chao Li Cc: Peter Smith , PostgreSQL Hackers Subject: Re: DOCS - DROP SUBSCRIPTION does not document parameter "IF EXISTS" Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 01, 2026 at 02:43:15PM +0800, Chao Li wrote: > On Apr 1, 2026, at 14:16, Peter Smith wrote: >> PSA a patch to add similar documentation for DROP SUBSCRIPTION IF EXISTS. > > Looks good. The patch uses the same phrase for “if exists” as the doc of > “drop publication”. And I verified that a notice is issued: Thanks. Will commit/back-patch shortly. -- nathan