Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ns4TU-00055z-Ri for pgsql-bugs@arkaria.postgresql.org; Fri, 20 May 2022 15:23:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ns4TT-0000r1-J0 for pgsql-bugs@arkaria.postgresql.org; Fri, 20 May 2022 15:23:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ns4TS-0000qs-GE for pgsql-bugs@lists.postgresql.org; Fri, 20 May 2022 15:23:31 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ns4TO-0006X1-7l for pgsql-bugs@lists.postgresql.org; Fri, 20 May 2022 15:23:30 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 9EF9032002E2; Fri, 20 May 2022 11:23:22 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Fri, 20 May 2022 11:23:23 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1653060202; x=1653146602; bh=e rqRFRYuGzVJJzhzXUVldFgvGzpuFo4rYAa4N8KD95U=; b=N82i+k+9AVuj+rVzR AWKMqRw1nW4vPlj/D7Zdb9Uxyx0sFNC/huWJODrfKtdU73x0Y30UzmoZNjTnh6vH 1Re3I19QehFAbJmDMBz4SHCDrqWf6ex7dQ01FQIkHqGZ2OCEFAOl5q/a8Q4xFo4T wFDJ2FLoRZwWWg6KeoZws7ouvTvAQ/NMvQRWbwSyfpXbfdKzBO3Gmg+CB4t80lpe iQyedcFizEhodF7rQfcRlhNXOsrXM+P6js0rcMopyESws8J8Lcr2EVhJSG0kz94/ owBN70bIDFo0aRNBRQp5WL6aw8hs36+2z3r5Fk/3/brjEmQ645qSI0K71WsEA7HO IxxvQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrieefgdekjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfggtggugfgjsehmkeerredttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpeduleekkefgtddttedtkefguddvieffleetgeejiefhteeh keevfeettdduvdfhueenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 20 May 2022 11:23:21 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 22DC22A2204; Fri, 20 May 2022 17:23:19 +0200 (CEST) Date: Fri, 20 May 2022 17:23:19 +0200 From: Alvaro Herrera To: Masahiko Sawada Cc: Michael Paquier , Amit Kapila , LEMAIRE Leslie =?utf-8?Q?=28Charg=C3=A9e_de_mission?= =?utf-8?Q?=29?= - SG/SNUM/UNI/DRC , PostgreSQL mailing lists Subject: Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Message-ID: <202205201523.7m5jbfvyanmj@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="kceutoikrbr7dfaw" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202205201412.jrrbxaotej3z@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --kceutoikrbr7dfaw Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On 2022-May-20, Alvaro Herrera wrote: > On 2022-May-20, Masahiko Sawada wrote: > > > I think that the event trigger that emits these NOTICE messages > > doesn't exist in 13 or older branches. It was added by 2d689babe3c. > > Oh, hahah. Hmm, I feel inclined to add the trigger rather than remove > the lines from the expected output. So I'm inclined to add the attached patch before the bugfix, in branches 10-13. It simply adds the new event trigger to the existing test case, being careful not to trip on the error message that it would generate otherwise, for a bug that was only fixed in 14. The other option, of course, is to not backpatch any of this earlier than 14. But the OP says she was experimenting with version 10 initially. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Java is clearly an example of money oriented programming" (A. Stepanov) --kceutoikrbr7dfaw Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="0001-add-regression-tests-by-2d689babe3cb.patch"