Hi Adrian,On Fri, 29 Sep 2023 14:27:48 -0700 Adrian Klaver wrote:
>On 9/29/23 1:37 PM, pf@pfortin.com wrote:
>> Hi,
>>
>> select version();
>> PostgreSQL 15.4 on x86_64-mageia-linux-gnu,
>> compiled by gcc (Mageia 12.3.0-3.mga9) 12.3.0, 64-bit
>>
>> 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?
>>
>>
>> Simplified statements; just trying to import a subset of columns:
>>
>> DROP TABLE IF EXISTS t;
>>
>> CREATE TABLE IF NOT EXISTS t (
>> f1 text, f2 text, f3 text, f4 text, f5 text );
>>
>> COPY t ( -- import only a subset of columns
>
>I'm going to say it is the
>
>( -- import only a subset of columns
>
>I suspect the -- comment is the issue.
I wish it was that easy. It's not in the code; I added that as a
clarification within the email only.
>You need to show the actual Python code for a more complete answer.
Attached...
Source file (44,530 records):
https://s3.amazonaws.com/dl.ncsbe.gov/data/ncvoter53.zip
Attached is a 10 row (incl. header) sample file.
$ dbcopy_voter2 /tmp/ncvoter53_10.txt test ncv53 <db_password>
>> f1, f3, f5 ) FROM '/tmp/foo.txt'
>> WITH (FORMAT CSV, HEADER, DELIMITER ' ', ENCODING 'ISO-8859-1') ;
>>
>> ERROR: cache lookup failed for function 0
>> Where: COPY t, line 1
>> 1 statement failed.
>>
>> "function"? Is this referring to an implied/internal function? Searching
>> has not provided any clue, yet...
>>
>> There are no user functions in the database:
>> ostgres=# \df
>> List of functions
>> Schema | Name | Result data type | Argument data types | Type
>> --------+------+------------------+---------------------+------
>> (0 rows)
>>
>> It feels like something changed since the previously working script no
>> longer works...
>>
>> Clues?
>>
>> Thanks,
>> Pierre
>>
>>
>>
>
>