From: Adrian Klaver <adrian.klaver@aklaver.com>
To: pf@pfortin.com
To: pgsql-general@lists.postgresql.org
Subject: Re: cache lookup failed for function 0
Date: Sat, 30 Sep 2023 08:50:45 -0700
Message-ID: <f9aa81f1-1977-4e0f-b2f8-341b68e5c05a@aklaver.com> (raw)
In-Reply-To: <20230930100132.44da3c45@pfortin.com>
References: <20230929163739.3bea46e5.pfortin@pfortin.com>
<8fd58b4c-ef57-3218-b7e3-f087e15db784@aklaver.com>
<20230930100132.44da3c45@pfortin.com>
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.
>
> $ dbcopy_voter2 /tmp/ncvoter53_10.txt test ncv53 <db_password>
Not sure what the above is supposed to be doing?
What I was looking for is the Python code snippet where you actually run
the COPY.
Also per Tom's post information on whether there are extensions
installed or if there is an event trigger running?
>
>
>>> f1, f3, f5 ) FROM '/tmp/foo.txt'
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, pf@pfortin.com
Subject: Re: cache lookup failed for function 0
In-Reply-To: <f9aa81f1-1977-4e0f-b2f8-341b68e5c05a@aklaver.com>
References: <20230929163739.3bea46e5.pfortin@pfortin.com> <8fd58b4c-ef57-3218-b7e3-f087e15db784@aklaver.com> <20230930100132.44da3c45@pfortin.com> <f9aa81f1-1977-4e0f-b2f8-341b68e5c05a@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox