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 1qmcF8-008HRa-Op for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 15:50:59 +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 1qmcF5-00D23v-LR for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 15:50:55 +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 1qmcF3-00D1sh-L9 for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 15:50:55 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmcF0-007SjZ-2j for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 15:50:52 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 843423200094; Sat, 30 Sep 2023 11:50:47 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Sat, 30 Sep 2023 11:50:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm1; t= 1696089047; x=1696175447; bh=aynV0HSPalCzFCoUBob0xNfQ/UmYhAvAc1I Qr2rVttQ=; b=ZBWM1W9EbU/hjelBsBi7cU0aQa32jrkzdD4GcN/vRFwD5S7p314 nm+Un9GdhDYPIjrcHHRoZ803onlXfh/5OyUIYfqJsidG3lRNCehZcIEuuYcK3AYD MTVbaeZZRGRvTgKasR66E4DyYeG2GuLXYFBTGjmvxD8cFhi68ZLYDfqITTBlNGYB uK8uQRbmZE/5ryiDx8sMrb5HZ/O/KRD+NlZH0p9TTiI4FC8qHX/LNxvrWURm/hvC Jx56VJDZIvxZkw0pb44IKnGtQc+rHSRKszf95Uh7KWGyz+bCggrwy8JRfUPxeIgf 9q8UJB/8/fx1TDmcPkKzgN74a9BCtVXfV3g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1696089047; x= 1696175447; bh=aynV0HSPalCzFCoUBob0xNfQ/UmYhAvAc1IQr2rVttQ=; b=q rJFRhwR28f39R/WxmmoOpqxTXmGJkCZ8MbfB37zG0lPQhTwObiwRkr5nIkOnBfui e0Uj2m7gLhPrqs4hFL9WO2rq1DekCK3EPJ9JEJcmIjx4GMHU2f42F/sUHV6ExIT8 HsP6xl3ubsmqpB0QLf0MkoBpudqGD86MStW7ARD82oKl52TYybcb9Wq9FygZ8HCr T/Hn/mk7xKpG5/NVbfv20+8N84CLDO4mfE6VpzcwzOcsxaKytW7CExP8DV8xi4s6 RY7xslRlhqmww3YYlYd/z5epC2qbDJqnoY4dKz29rhok6OUhMAupnlqUFzvLX8mw 1GfcPp5svikBFphNGBAgQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedruddugdefudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuffvfhfhjggtgfesthejre dttddvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhl rghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpedufefhhfekie ffffelveeiteehueelkedvgfeludfgvdefgfdvtddthfetffehffenucffohhmrghinhep rghmrgiiohhnrgifshdrtghomhdpnhgtshgsvgdrghhovhenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegr khhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 30 Sep 2023 11:50:46 -0400 (EDT) Message-ID: Date: Sat, 30 Sep 2023 08:50:45 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: cache lookup failed for function 0 To: pf@pfortin.com, pgsql-general@lists.postgresql.org References: <20230929163739.3bea46e5.pfortin@pfortin.com> <8fd58b4c-ef57-3218-b7e3-f087e15db784@aklaver.com> <20230930100132.44da3c45@pfortin.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <20230930100132.44da3c45@pfortin.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 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