Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmcwI-008LSg-Hg for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 16:35:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qmcwG-00DmqI-Pa for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 16:35:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmcwG-00Dmpl-9o for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 16:35:32 +0000 Received: from rs6162.luxsci.com ([162.142.76.255]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmcwD-007SzJ-A3 for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 16:35:31 +0000 Received: from pfortin.com (h128.249.89.75.dynamic.ip.windstream.net [75.89.249.128]) (authenticated bits=0) by rs6162.luxsci.com (8.15.2/8.14.9) with ESMTPSA id 38UGZROn1303956 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT) for ; Sat, 30 Sep 2023 16:35:28 GMT Date: Sat, 30 Sep 2023 12:35:27 -0400 From: pf@pfortin.com To: pgsql-general@lists.postgresql.org Subject: Re: cache lookup failed for function 0 Message-ID: <20230930123527.4efb81e4@pfortin.com> In-Reply-To: References: <20230929163739.3bea46e5.pfortin@pfortin.com> <8fd58b4c-ef57-3218-b7e3-f087e15db784@aklaver.com> <20230930100132.44da3c45@pfortin.com> X-Mailer: Claws Mail 4.1.1git67 (GTK 3.24.38; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="MP_/v.Veqya4O_Rh1Wqrlg1XtF7" X-Lux-Comment: Message 38UGZROn1303956 sent by user #22429 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pfortin.com; h=date:from:to:subject:message-id:in-reply-to:references:mime-version:content-type; s=dkim; bh=zlq2xKW4FUTdpHSJuJILdu5S4ZDuA1bMWq7wFQYF8Z4=; b=w62IuaEpxvpU88M/O5Z1GGp1KjME+oRQ/RezIaYuPg6grx85kB4BEfb0yg8toMHRV445KahljoRwbb6D20N1xhCUzoQCPE+ndpyaWfl+uNGOVgIa8dIAAdIk/A5pcP2zcwiAitHr1XWTCLd57itg0NwH62Ekz0ZLkFEm5xH2iAQ= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --MP_/v.Veqya4O_Rh1Wqrlg1XtF7 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 " e.g.: >> $ dbcopy_voter2 /tmp/ncvoter53_10.txt test ncv53 > >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 --MP_/v.Veqya4O_Rh1Wqrlg1XtF7 Content-Type: application/octet-stream; name=dbcopy_voter2 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=dbcopy_voter2 IyEvYmluL3B5dGhvbgojIC0qLSBtb2RlOiBweXRob247IC0qLQojIAojIENvcHlyaWdodDoKIyAg ICAyMDIzLVByZXNlbnQsIFBpZXJyZSBGb3J0aW4sIDxwaWVycmVATkNEYXRhVGVhbS5vcmc+CiMg TGljZW5zZToKIyAgICBHUEx2MyBvciBhbnkgbGF0ZXIgdmVyc2lvbjogaHR0cHM6Ly93d3cuZ251 Lm9yZy9saWNlbnNlcy9ncGwtMy4wLmVuLmh0bWwKIyBDcmVhdGVkOgojICAgIDIwMjMtMDktMjMg SW5pdGlhbCBzY3JpcHQKIyBVcGRhdGVkOiAKCiMgQ2FsbDoKIyAgICBkYmNvcHkgZmYgPGlucHV0 X2ZpbGU+IDx0YWJsZV9uYW1lPgoKIyBFeGFtcGxlczoKIyAgICBkYmNvcHkgZmYgL3RtcC9uY3Zv dGVyNTMudHh0IHRlc3QgbmN2b3RlcjUzCiMgICAgVG90YWwgcHJvY2Vzc2luZyB0aW1lOiAxLjY4 MXMKIwojICAgIGRiY29weSBmZiAvdG1wL25jdm90ZXJfU3RhdGV3aWRlLnR4dCB0ZXN0IG5jdm90 ZXJfU3RhdGV3aWRlCiMKCiMgRGVmYXVsdHMKSU5QVVQgPSAnL3RtcC9uY3ZvdGVyX1N0YXRld2lk ZS50eHQnClVTRVIgPSAncG9zdGdyZXMnClBXID0gJycKREIgPSAndGVzdCcKVEFCTEUgPSAndGFi bGUnCgpGSUVMRFMgPSBbICAjIFt1bl1jb21tZW50IHRoZSBhcHByb3ByaWF0ZSBsaW5lcwogICAg IydyaWQgaW50IEdFTkVSQVRFRCBBTFdBWVMgQVMgSURFTlRJVFkgUFJJTUFSWSBLRVknLAogIAog ICAgJ2NvdW50eV9pZCBpbnQnLAogICAgJ2NvdW50eV9kZXNjIHRleHQnLAogICAgJ3ZvdGVyX3Jl Z19udW0gYmlnaW50JywKICAgICduY2lkIHRleHQgUFJJTUFSWSBLRVknLAogICAgIyduY2lkIHRl eHQnLAogICAgJ2xhc3RfbmFtZSB0ZXh0JywKICAgICdmaXJzdF9uYW1lIHRleHQnLAogICAgJ21p ZGRsZV9uYW1lIHRleHQnLAogICAgJ25hbWVfc3VmZml4X2xibCB0ZXh0JywKICAgICdzdGF0dXNf Y2QgdGV4dCcsCiAgICAndm90ZXJfc3RhdHVzX2Rlc2MgdGV4dCcsCiAgICAncmVhc29uX2NkIHRl eHQnLAogICAgJ3ZvdGVyX3N0YXR1c19yZWFzb25fZGVzYyB0ZXh0JywKICAgICdyZXNfc3RyZWV0 X2FkZHJlc3MgdGV4dCcsCiAgICAncmVzX2NpdHlfZGVzYyB0ZXh0JywKICAgICdzdGF0ZV9jZCB0 ZXh0JywKICAgICd6aXBfY29kZSB0ZXh0JywKICAgICdtYWlsX2FkZHIxIHRleHQnLAogICAgJ21h aWxfYWRkcjIgdGV4dCcsCiAgICAnbWFpbF9hZGRyMyB0ZXh0JywKICAgICdtYWlsX2FkZHI0IHRl eHQnLAogICAgJ21haWxfY2l0eSB0ZXh0JywKICAgICdtYWlsX3N0YXRlIHRleHQnLAogICAgJ21h aWxfemlwY29kZSB0ZXh0JywKICAgICdmdWxsX3Bob25lX251bWJlciB0ZXh0JywKICAgICdjb25m aWRlbnRpYWxfaW5kIHRleHQnLAogICAgJ3JlZ2lzdHJfZHQgZGF0ZScsCiAgICAncmFjZV9jb2Rl IHRleHQnLAogICAgJ2V0aG5pY19jb2RlIHRleHQnLAogICAgJ3BhcnR5X2NkIHRleHQnLAogICAg J2dlbmRlcl9jb2RlIHRleHQnLAogICAgJ2JpcnRoX3llYXIgaW50JywKICAgICdhZ2VfYXRfeWVh cl9lbmQgaW50JywKICAgICdiaXJ0aF9zdGF0ZSB0ZXh0JywKICAgICdkcml2ZXJzX2xpYyB0ZXh0 JywKICAgICdwcmVjaW5jdF9hYmJydiB0ZXh0JywKICAgICdwcmVjaW5jdF9kZXNjIHRleHQnLAog ICAgJ211bmljaXBhbGl0eV9hYmJydiB0ZXh0JywKICAgICdtdW5pY2lwYWxpdHlfZGVzYyB0ZXh0 JywKICAgICd3YXJkX2FiYnJ2IHRleHQnLAogICAgJ3dhcmRfZGVzYyB0ZXh0JywKICAgICdjb25n X2Rpc3RfYWJicnYgdGV4dCcsCiAgICAnc3VwZXJfY291cnRfYWJicnYgdGV4dCcsCiAgICAnanVk aWNfZGlzdF9hYmJydiB0ZXh0JywKICAgICduY19zZW5hdGVfYWJicnYgdGV4dCcsCiAgICAnbmNf aG91c2VfYWJicnYgdGV4dCcsCiAgICAnY291bnR5X2NvbW1pc3NfYWJicnYgdGV4dCcsCiAgICAn Y291bnR5X2NvbW1pc3NfZGVzYyB0ZXh0JywKICAgICd0b3duc2hpcF9hYmJydiB0ZXh0JywKICAg ICd0b3duc2hpcF9kZXNjIHRleHQnLAogICAgJ3NjaG9vbF9kaXN0X2FiYnJ2IHRleHQnLAogICAg J3NjaG9vbF9kaXN0X2Rlc2MgdGV4dCcsCiAgICAnZmlyZV9kaXN0X2FiYnJ2IHRleHQnLAogICAg J2ZpcmVfZGlzdF9kZXNjIHRleHQnLAogICAgJ3dhdGVyX2Rpc3RfYWJicnYgdGV4dCcsCiAgICAn d2F0ZXJfZGlzdF9kZXNjIHRleHQnLAogICAgJ3Nld2VyX2Rpc3RfYWJicnYgdGV4dCcsCiAgICAn c2V3ZXJfZGlzdF9kZXNjIHRleHQnLAogICAgJ3Nhbml0X2Rpc3RfYWJicnYgdGV4dCcsCiAgICAn c2FuaXRfZGlzdF9kZXNjIHRleHQnLAogICAgJ3Jlc2N1ZV9kaXN0X2FiYnJ2IHRleHQnLAogICAg J3Jlc2N1ZV9kaXN0X2Rlc2MgdGV4dCcsCiAgICAnbXVuaWNfZGlzdF9hYmJydiB0ZXh0JywKICAg ICdtdW5pY19kaXN0X2Rlc2MgdGV4dCcsCiAgICAnZGlzdF8xX2FiYnJ2IHRleHQnLAogICAgJ2Rp c3RfMV9kZXNjIHRleHQnLAogICAgJ3Z0ZF9hYmJydiB0ZXh0JywKICAgICd2dGRfZGVzYyB0ZXh0 JywKXQpmaWVsZHMgPSBbIHguc3BsaXQoKVswXSBmb3IgeCBpbiBGSUVMRFMgXQoKCmltcG9ydCBv cwppbXBvcnQgc3lzCmltcG9ydCBwc3ljb3BnMgppbXBvcnQgdGltZQoKdHJ5OiAgSU5QVVQgPSBz eXMuYXJndlsxXQpleGNlcHQ6ICBwYXNzCgp0cnk6ICBEQiA9IHN5cy5hcmd2WzJdCmV4Y2VwdDog IHBhc3MKCnRyeTogIFRBQkxFID0gc3lzLmFyZ3ZbM10KZXhjZXB0OiAgcGFzcwoKdHJ5OiAgUFcg PSBzeXMuYXJndls0XQpleGNlcHQ6ICBwYXNzCgpBTlNJRXJhc2VMaW5lID0gJ1wwMzNbMktcMDMz WzFHJwpDT01NQSA9ICcsJwpOTCA9ICdcbicKQ09NTUFfTkwgPSBmIntDT01NQX17Tkx9IgpUQUIg PSAnXHQnCgpkZWYgcGUoICpzICk6CiAgICBmb3IgZWFjaCBpbiBzOgogICAgICAgIHByaW50KCBl YWNoLCBmaWxlID0gc3lzLnN0ZGVyciApCgpkZWYgc3FsKCBzICk6CiAgICAjIGlmIHMuc3RhcnRz d2l0aCggJ0NSRUFURSBJTkRFWCcgKTogIHByaW50KCBzICkKICAgICMgZWxzZTogIHByaW50KCBz LCBOTCApCiAgICBjdXIuZXhlY3V0ZSggcyApCiAgICAKY29ubiA9IHBzeWNvcGcyLmNvbm5lY3Qo CiAgICBob3N0ID0gJ2xvY2FsaG9zdCcsCiAgICBwb3J0ID0gJzU0MzInLAogICAgZGF0YWJhc2Ug PSBEQiwKICAgIHVzZXIgPSBVU0VSLAogICAgcGFzc3dvcmQgPSBQVwopCmN1ciA9IGNvbm4uY3Vy c29yKCkKCnNxbCggZiJEUk9QIFRBQkxFIElGIEVYSVNUUyB7VEFCTEV9OyIgKQpzcWwoIGYiQ1JF QVRFIFRBQkxFIElGIE5PVCBFWElTVFMge1RBQkxFfSAoe05MfXtDT01NQV9OTC5qb2luKEZJRUxE Uyl9e05MfSk7IiApCnNxbCggZiJDT1BZIHtUQUJMRX0gKHtOTH17Q09NTUFfTkwuam9pbihmaWVs ZHMpfXtOTH0pIEZST00gJ3tJTlBVVH0nIFdJVEggKEZPUk1BVCBDU1YsIEhFQURFUiwgREVMSU1J VEVSICdcdCcsIEVOQ09ESU5HICdJU08tODg1OS0xJyk7IiApCgpmb3IgaW5kZXggaW4gZmllbGRz OgogICAgc3FsKCBmIkNSRUFURSBJTkRFWCBJRiBOT1QgRVhJU1RTIGlkeF97VEFCTEV9X3tpbmRl eH0gb24ge1RBQkxFfSAoe2luZGV4fSk7IiApCgpzcWwoICdDT01NSVQ7JyApCgpzcWwoIGYiR1JB TlQgU0VMRUNULCBVUERBVEUsIElOU0VSVCwgREVMRVRFLCBSRUZFUkVOQ0VTLCBUUklHR0VSIE9O IHt0YWJsZX0gVE8gcG9zdGdyZXM7IiApCiNzcWwoIGYiR1JBTlQgVVNBR0UsIFNFTEVDVCwgVVBE QVRFIE9OIHt0YWJsZX1fcmlkX3NlcSBUTyBwb3N0Z3JlczsiICkKCg== --MP_/v.Veqya4O_Rh1Wqrlg1XtF7 Content-Type: text/plain Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=ncvoter53_10.txt "county_id" "county_desc" "voter_reg_num" "ncid" "last_name" "first_name" "middle_name" "name_suffix_lbl" "status_cd" "voter_status_desc" "reason_cd" "voter_status_reason_desc" "res_street_address" "res_city_desc" "state_cd" "zip_code" "mail_addr1" "mail_addr2" "mail_addr3" "mail_addr4" "mail_city" "mail_state" "mail_zipcode" "full_phone_number" "confidential_ind" "registr_dt" "race_code" "ethnic_code" "party_cd" "gender_code" "birth_year" "age_at_year_end" "birth_state" "drivers_lic" "precinct_abbrv" "precinct_desc" "municipality_abbrv" "municipality_desc" "ward_abbrv" "ward_desc" "cong_dist_abbrv" "super_court_abbrv" "judic_dist_abbrv" "nc_senate_abbrv" "nc_house_abbrv" "county_commiss_abbrv" "county_commiss_desc" "township_abbrv" "township_desc" "school_dist_abbrv" "school_dist_desc" "fire_dist_abbrv" "fire_dist_desc" "water_dist_abbrv" "water_dist_desc" "sewer_dist_abbrv" "sewer_dist_desc" "sanit_dist_abbrv" "sanit_dist_desc" "rescue_dist_abbrv" "rescue_dist_desc" "munic! _dist_abbrv" "munic_dist_desc" "dist_1_abbrv" "dist_1_desc" "vtd_abbrv" "vtd_desc" "53" "LEE" "000030002652" "CL31767" "AARON" "BARBARA" "M" " " "R" "REMOVED" "RD" "DECEASED" "REMOVED" "" "" "" " " " " " " " " " " " " " " "" "N" "10/02/2000" "B" "NL" "DEM" "F" "1953" "70" "MD" "N" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "53" "LEE" "000030036973" "CL60219" "AAZAMI" "KIARASH" "" "" "I" "INACTIVE" "IU" "CONFIRMATION RETURNED UNDELIVERABLE" "2111 WIMBERLY WOODS DR " "SANFORD" "NC" "27330" "2111 WIMBERLY WOODS DR" "" "" "" "SANFORD" "NC" "27330" "8189153666" "N" "09/14/2016" "O" "UN" "UNA" "M" "1972" "51" "" "Y" "D1" "PRECINCT D1" "01" "SANFORD" "1" "WARD #1" "09" "11A" "11" "12" "051" "4" "COMMISSION 4" "1" "WEST SANFORD" "" "" "" "" "" "" "" "" "" "" "" "" "01" "SANFORD" "12" "12TH PROSECUTORIAL" "D" "D" "53" "LEE" "000030036974" "CL60220" "AAZAMI" "LINDSAY" "LYNETTE" " " "R" "REMOVED" "RM" "REMOVED AFTER 2 FED GENERAL ELECTIONS IN INACTIVE STATUS" "REMOVED" "" "" "" " " " " " " " " " " " " " " "" "N" "09/14/2016" "W" "UN" "REP" "F" "1984" "39" "" "Y" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "53" "LEE" "000030002228" "CL31343" "ABARCA" "HUGO" "J" "JR" "I" "INACTIVE" "IN" "CONFIRMATION NOT RETURNED" "809 AMHERST RD " "SANFORD" "NC" "27330" "809 AMHERST RD" "" "" "" "SANFORD" "NC" "27330" "9197770446" "N" "07/24/2000" "O" "NL" "DEM" "M" "1980" "43" "IL" "Y" "A2" "PRECINCT A2" "" "" "" "" "09" "11A" "11" "12" "051" "1" "COMMISSION 1" "2" "EAST SANFORD" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "12" "12TH PROSECUTORIAL" "A" "A" "53" "LEE" "000030019012" "CL47087" "ABARCA" "SOPHIA" "" "" "A" "ACTIVE" "AV" "VERIFIED" "317 CHURCH ST " "SANFORD" "NC" "27330" "317 CHURCH ST" "" "" "" "SANFORD" "NC" "27330" "9197215455" "N" "09/10/2008" "O" "HL" "REP" "F" "1989" "34" "IL" "Y" "A1" "PRECINCT A1" "01" "SANFORD" "4" "WARD #4" "09" "11A" "11" "12" "051" "1" "COMMISSION 1" "1" "WEST SANFORD" "" "" "" "" "" "" "" "" "" "" "" "" "01" "SANFORD" "12" "12TH PROSECUTORIAL" "A" "A" "53" "LEE" "000030039023" "CL61374" "ABARCA" "TOMASA" "MENDOZA" "" "I" "INACTIVE" "IN" "CONFIRMATION NOT RETURNED" "809 AMHERST RD " "SANFORD" "NC" "27330" "809 AMHERST RD" "" "" "" "SANFORD" "NC" "27330" "9193564793" "N" "11/08/2016" "W" "HL" "LIB" "F" "1981" "42" "" "Y" "A2" "PRECINCT A2" "" "" "" "" "09" "11A" "11" "12" "051" "1" "COMMISSION 1" "2" "EAST SANFORD" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "12" "12TH PROSECUTORIAL" "A" "A" "53" "LEE" "000030048749" "CZ106255" "ABAY-ABAY" "CHRISTINE" "SUSAN" "" "A" "ACTIVE" "AV" "VERIFIED" "2149 LOWER MONCURE RD " "SANFORD" "NC" "27330" "2149 LOWER MONCURE RD" "" "" "" "SANFORD" "NC" "27330" "" "N" "05/11/2020" "W" "NL" "DEM" "U" "1991" "32" "" "Y" "A2" "PRECINCT A2" "" "" "" "" "09" "11A" "11" "12" "051" "2" "COMMISSION 2" "2" "EAST SANFORD" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "12" "12TH PROSECUTORIAL" "A" "A" "53" "LEE" "000030014928" "CL43691" "ABBEY" "DALE" "ALAN" " " "R" "REMOVED" "RD" "DECEASED" "REMOVED" "" "" "" " " " " " " " " " " " " " " "" "N" "01/26/2007" "W" "NL" "DEM" "M" "1939" "84" "NY" "Y" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "53" "LEE" "000030046131" "CZ85838" "ABBONDANZIO" "JODIE" "LEE" "" "A" "ACTIVE" "AV" "VERIFIED" "171 PEACEFUL LN " "SANFORD" "NC" "27330" "171 PEACEFUL LN" "" "" "" "SANFORD" "NC" "27330" "" "N" "08/27/2019" "U" "UN" "UNA" "U" "1992" "31" "" "Y" "B2" "PRECINCT B2" "01" "SANFORD" "2" "WARD #2" "09" "11A" "11" "12" "051" "2" "COMMISSION 2" "1" "WEST SANFORD" "" "" "" "" "" "" "" "" "" "" "" "" "01" "SANFORD" "12" "12TH PROSECUTORIAL" "B" "B" --MP_/v.Veqya4O_Rh1Wqrlg1XtF7--