From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pf(at)pfortin(dot)com |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: cache lookup failed for function 0 |
Date: | 2023-09-29 22:21:02 |
Message-ID: | 1418544.1696026062@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
pf(at)pfortin(dot)com writes:
> As a test, rather than use INSERT, I recently wrote a python test script
> to import some 8M & 33M record files with COPY instead. These worked with
> last weekend's data dump. Next, I wanted to look into importing a subset
> of columns using the below logic; but I'm getting "ERROR: cache lookup
> failed for function 0". Re-running the same full imports that worked
> Saturday, I now get the same error.
> Could something in the DB cause this "function" error?
"cache lookup failed" certainly smells like a server internal error,
but we'd have heard about it if the trivial case you show could reach
such a problem. I'm thinking there's things you haven't told us.
What extensions do you have installed? Maybe an event trigger?
Also, the reference to ENCODING 'ISO-8859-1' makes me wonder what
encoding conversion is being performed.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Raivo Rebane | 2023-09-30 05:01:27 | Re: Right version of jdbc |
Previous Message | Adrian Klaver | 2023-09-29 21:27:48 | Re: cache lookup failed for function 0 |