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 1nmC50-0005TE-BZ for pgsql-bugs@arkaria.postgresql.org; Wed, 04 May 2022 10:17:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nmC4z-0004A9-1r for pgsql-bugs@arkaria.postgresql.org; Wed, 04 May 2022 10:17:57 +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 1nmC4y-00049z-1D for pgsql-bugs@lists.postgresql.org; Wed, 04 May 2022 10:17:56 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nmC4u-0006t7-8e for pgsql-bugs@lists.postgresql.org; Wed, 04 May 2022 10:17:55 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 6CC125C01B4; Wed, 4 May 2022 06:17:49 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Wed, 04 May 2022 06:17:49 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date: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=1651659469; x=1651745869; bh=EJB1YvIDD7Nz+Ni8peebDkqrUL09 sWMJS7HsVEJSgDY=; b=OicWvFkMNe6z1RUHb7dJi+cJLerXHmRg0dIkkvDmeu3O cACFzLL98mqYxHXBDjVrs/umqaqJlqD4Nl+ZjkEcA4Qs7SVl/wya3MiDtV4kcAra A8Xxm5h0UAa3YD/zueS0LYiyWV5sfbuWezqIR0xov8q0+JO6omo30WKOvZ5Dshac 8OJI4EjV8sg3D4e6s7Y97OGkTOEhADPgfUav4WOVwJlqK0GftdEvy93i0IkIAtHc a87UG5q4w4jMm+/V2x0thUbyS3rcXdkv242Z0U8G8pvIcfdIcmVru3wHsJSAqm94 o30zldiopJOiu2bEbumfHntddh5VaLYTnOOzuVag8g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrvdelgddviecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeejkeff gfdufffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 4 May 2022 06:17:48 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 16FEF2A0400; Wed, 4 May 2022 12:17:46 +0200 (CEST) Date: Wed, 4 May 2022 12:17:46 +0200 From: Alvaro Herrera To: LEMAIRE Leslie =?utf-8?Q?=28Charg=C3=A9e_de_mission?= =?utf-8?Q?=29?= - SG/SNUM/UNI/DRC Cc: pgsql-bugs@lists.postgresql.org Subject: Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands Message-ID: <202205041017.uc3dxylntais@alvherre.pgsql> 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 2022-May-02, LEMAIRE Leslie (Chargée de mission) - SG/SNUM/UNI/DRC wrote: > As stated in the documentation [1], creating an operator class without > specifying the FAMILY option will create an operator family with the same > name as the new class if it doesn't already exist. In this case, my event > trigger is activated through the "CREATE OPERATOR CLASS" tag as usual, but > pg_event_trigger_ddl_commands() still returns only one row - for the > operator class creation. I would have expected it to list the creation of > the operator family as well. I agree, this looks like an omission somewhere -- the extra object should have been reported. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/