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.94.2) (envelope-from ) id 1qmddd-008OM5-UJ for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 17:20:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qmddc-00ECzM-Ed for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 17:20:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmddc-00ECyp-2n for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 17:20:20 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmddZ-008Tbo-2T for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 17:20:19 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 38UHKE651561294; Sat, 30 Sep 2023 13:20:14 -0400 From: Tom Lane To: pf@pfortin.com cc: pgsql-general@lists.postgresql.org Subject: Re: cache lookup failed for function 0 In-reply-to: <20230930123527.4efb81e4@pfortin.com> References: <20230929163739.3bea46e5.pfortin@pfortin.com> <8fd58b4c-ef57-3218-b7e3-f087e15db784@aklaver.com> <20230930100132.44da3c45@pfortin.com> <20230930123527.4efb81e4@pfortin.com> Comments: In-reply-to pf@pfortin.com message dated "Sat, 30 Sep 2023 12:35:27 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1561292.1696094414.1@sss.pgh.pa.us> Date: Sat, 30 Sep 2023 13:20:14 -0400 Message-ID: <1561293.1696094414@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk pf@pfortin.com writes: > Python script and sample file attached... This runs fine for me, both in HEAD and 15.4. (Well, it fails at the last GRANT, seemingly because you wrote "{table}" not "{TABLE}". But the COPY goes through fine.) Assuming that you verified that this specific test case fails for you, we're down to just a couple of theories: 1. There's some relevant info you didn't supply yet (is it really a completely plain-vanilla installation? Maybe some odd choice of locale?) 2. There's something wrong with your Postgres installation. It's hard to get much further than that with the info that we have. regards, tom lane