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 1lGOkh-0008Kh-EK for pgsql-bugs@arkaria.postgresql.org; Sun, 28 Feb 2021 16:17:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lGOk9-0006Qh-Jz for pgsql-bugs@arkaria.postgresql.org; Sun, 28 Feb 2021 16:16:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lGOk8-0006Qa-Ne for pgsql-bugs@lists.postgresql.org; Sun, 28 Feb 2021 16:16:29 +0000 Received: from [64.147.123.24] (helo=wout1-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lGOk2-0001Ur-1A for pgsql-bugs@lists.postgresql.org; Sun, 28 Feb 2021 16:16:27 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.west.internal (Postfix) with ESMTP id 94A168D6; Sun, 28 Feb 2021 11:16:09 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Sun, 28 Feb 2021 11:16:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=L8/vSOIaxyPGLNWw7fqHLB2gx9hHdlo7o04BorHVz8c=; b=iSTDS+Of 70MjCI1oFSa2khXFM3cAA5RsRHkHF2WLRaT4TAfA9m0J/aiPMx/rXZpNzs3r3oSm 1zFOv1cIIvgDTvcte2ln6rcgXGAzLK1Pe6kc5YBuSNyNUBNdubF8gv0geu+y6VA1 oHce6QFbyxP/MuQq5DPYaPTMRp74H1mnRSUJn+RkRZyJ1JunPlrD8T9MsdQ9ljn8 J/cZG/j9Qj5h0MhoiFPMm46VM7kxDsBGVvpuBedht/jMs49LYyCzmWQYwtEIu0UD fS2omDp/xG/AvYQRnESGZlV3F2jdI4HUgqBTZGFRsoHaWYkocACWL4HQRAiKcfRe 2W1Dx59oJF/5zA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrleeigdekkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvuffkgggtugfgjggfsehtkeertddtredunecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpeevjeejkeejjeeiveeuuddvfeffiefhfffgleehgfeugeej heduvdefkeeihffftdenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgnecukf hppeduledtrdelhedrudelrdelheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgr mhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95]) by mail.messagingengine.com (Postfix) with ESMTPA id 97F4F108005F; Sun, 28 Feb 2021 11:16:08 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 221162A0F3C; Sun, 28 Feb 2021 13:16:06 -0300 (-03) Date: Sun, 28 Feb 2021 13:16:06 -0300 From: Alvaro Herrera To: Sven Klemm Cc: pgsql-bugs@lists.postgresql.org Subject: Re: pg_event_trigger_ddl_commands fails with cache lookup failed Message-ID: <20210228161606.GA21845@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.24 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2021-Feb-27, Sven Klemm wrote: > Hello, > > > trg=# ALTER TABLE t ALTER COLUMN f1 DROP IDENTITY, ALTER COLUMN f1 SET > > DATA TYPE bigint; > > ERROR: XX000: cache lookup failed for relation 13476892 > > CONTEXT: PL/pgSQL function ddl_end() line 5 at FOR over SELECT rows > > LOCATION: getRelationTypeDescription, objectaddress.c:4178 > > Is this expected behaviour or something that should be fixed? > The documentation for pg_event_trigger_ddl_commands doesnt mention > that it could fail for certain statements. Yeah, this is certainly a bug. The code should likely ignore the sub-command. I'll have a look. -- Álvaro Herrera Valdivia, Chile "After a quick R of TFM, all I can say is HOLY CR** THAT IS COOL! PostgreSQL was amazing when I first started using it at 7.2, and I'm continually astounded by learning new features and techniques made available by the continuing work of the development team." Berend Tober, http://archives.postgresql.org/pgsql-hackers/2007-08/msg01009.php