Re: cache lookup failed for function 0 - Mailing list pgsql-general

From pf@pfortin.com
Subject Re: cache lookup failed for function 0
Date
Msg-id 20230930123527.4efb81e4@pfortin.com
Whole thread Raw
In response to Re: cache lookup failed for function 0  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: cache lookup failed for function 0
List pgsql-general
On Sat, 30 Sep 2023 08:50:45 -0700 Adrian Klaver wrote:

>On 9/30/23 07:01, pf@pfortin.com wrote:
>> 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,  
>
>>> 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.  
>
>I am not seeing the sample file.

Sorry; I think I hit CTRL+Enter which sent that message before I was done.
Then, I was outside with the HVAC guy repairing my heat pump... 

Python script and sample file attached...

Invoke it with:  "dbcopy_voter2 <source> <db> <table> <db_pw>"
e.g.:
>> $ dbcopy_voter2 /tmp/ncvoter53_10.txt test ncv53 <db_password>  
>
>Not sure what the above is supposed to be doing?

Importing the data via a COPY.

>What I was looking for is the Python code snippet where you actually run 
>the COPY.

Attached this time...  Again, sorry about the incomplete message earlier.

>Also per Tom's post information on whether there are extensions 
>installed or if there is an event trigger running?

Replied to Tom.

Thanks,
Pierre

Attachment

pgsql-general by date:

Previous
From: pf@pfortin.com
Date:
Subject: Re: cache lookup failed for function 0
Next
From: Tom Lane
Date:
Subject: Re: cache lookup failed for function 0