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 1qmelz-008TrH-E1 for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 18:33:03 +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 1qmelx-00Eg62-TJ for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 18:33:01 +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.94.2) (envelope-from ) id 1qmelx-00Eg4i-4R for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 18:33:01 +0000 Received: from rs6162.luxsci.com ([162.142.76.255]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmelt-007TpH-N8 for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 18:32:59 +0000 Received: from pfortin.com (h128.249.89.75.dynamic.ip.windstream.net [75.89.249.128]) (authenticated bits=0) by rs6162.luxsci.com (8.15.2/8.14.9) with ESMTPSA id 38UIWtH71395030 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT) for ; Sat, 30 Sep 2023 18:32:55 GMT Date: Sat, 30 Sep 2023 14:32:55 -0400 From: pf@pfortin.com To: pgsql-general@lists.postgresql.org Subject: Re: cache lookup failed for function 0 Message-ID: <20230930143255.0d278307@pfortin.com> In-Reply-To: <1561293.1696094414@sss.pgh.pa.us> References: <20230929163739.3bea46e5.pfortin@pfortin.com> <8fd58b4c-ef57-3218-b7e3-f087e15db784@aklaver.com> <20230930100132.44da3c45@pfortin.com> <20230930123527.4efb81e4@pfortin.com> <1561293.1696094414@sss.pgh.pa.us> X-Mailer: Claws Mail 4.1.1git67 (GTK 3.24.38; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Lux-Comment: Message 38UIWtH71395030 sent by user #22429 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pfortin.com; h=date:from:to:subject:message-id:in-reply-to:references:mime-version:content-type:content-transfer-encoding; s=dkim; bh=5d0IVSUbCdj6sfbgdERW77Go+H62kN/fC0dyX0dj3Ik=; b=RUiIPN493LMpM/AlF+dIl8xEVmsLkbVGchPQ9fXEvOoFI51CvVUrbGIW/WrBE1+V2LE5VHtQWTRT/ry4Q1sW2UFBTcqRTYQmpivB99Lqi9ZDH6+fKZiVuT3LaGErC9UVHANh3ErUpVwxpLxZLudxkx0MZVxXfTlh8tccLo5ckw8= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 30 Sep 2023 13:20:14 -0400 Tom Lane wrote: >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.) Sorry, I ripped out some other test code which would have been unnecessarily confusing; but couldn't check the remaining bits due to the prior failure... >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?) As vanilla as it gets... Standard locale (C). The only odd thing that happened: a system update the other day installed and started something called tracker-miners which I was not happy with: https://bugs.mageia.org/show_bug.cgi?id=32340 I was quite upset that the distro guys would install/run what they thought could be a "cool" tool (as you'll see in the above link). >2. There's something wrong with your Postgres installation. Scary; but that's what I'm suspecting too now... >It's hard to get much further than that with the info that >we have. Understood; I wasn't sure which rabbit hole to go down; but this is starting to smell like a DB issue... I'll see about re-installing the server and pray the DB is sane... If the above tracker-miners found my postgres installation and added something to it; then I will be EXTREMELY upset... Thanks for confirming my simple SQL runs... > regards, tom lane Thanks Tom!