From: | pf(at)pfortin(dot)com |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: cache lookup failed for function 0 |
Date: | 2023-09-30 16:35:27 |
Message-ID: | 20230930123527.4efb81e4@pfortin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, 30 Sep 2023 08:50:45 -0700 Adrian Klaver wrote:
>On 9/30/23 07:01, pf(at)pfortin(dot)com wrote:
>> Hi Adrian,On Fri, 29 Sep 2023 14:27:48 -0700 Adrian Klaver wrote:
>>
>>> On 9/29/23 1:37 PM, pf(at)pfortin(dot)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 | Content-Type | Size |
---|---|---|
dbcopy_voter2 | application/octet-stream | 3.6 KB |
ncvoter53_10.txt | text/plain | 4.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-09-30 17:20:14 | Re: cache lookup failed for function 0 |
Previous Message | pf | 2023-09-30 16:33:06 | Re: cache lookup failed for function 0 |