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 1sRYtY-00GVey-73 for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 15:06:12 +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 1sRYtW-006CI6-PK for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 15:06:10 +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 1sRYtV-006CHg-Gd for pgsql-general@lists.postgresql.org; Wed, 10 Jul 2024 15:06:10 +0000 Received: from fout8-smtp.messagingengine.com ([103.168.172.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRYtP-001O89-Av for pgsql-general@postgresql.org; Wed, 10 Jul 2024 15:06:08 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfout.nyi.internal (Postfix) with ESMTP id E1348138163A; Wed, 10 Jul 2024 11:06:01 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Wed, 10 Jul 2024 11:06:01 -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:subject:subject:to:to; s=fm1; t=1720623961; x=1720710361; bh=xr9tBqKOmlXpCPcuz5ZbYj9AIqCjpTd4UzRRBXR/aJQ=; b= wJy5C6RKwEUYn7Ac88vnZ9vlHmtnkKHfaD3BNLUq1/7+MOKOJJ7OWZzjvV+tY9Qr eF6LQkzD44t8QDfrYmyjGCf/l+e5eyIufM0h9to0uZ+JR0G9ViYgPqAy5jELEalo dgVc0s/YNXlbY88vR22w9fXJPSj25EdKWXUzONic5RS8g6N7hRIrhSZRrw3CmHUz NlWJ+IkSZxhLnsQDKhVim1poliUwGcBbzB7f7AVghAGT+RqLcZ7loUVlxxjNsrV1 H2l4+NmL7HuxbzLfE2ig4+1mCfXjdKZzwQRD1yIuFPprcHtLDP4mMCBZbzRRSR7/ 4oP/SWJ8JsXgpyVGImL09w== 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:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1720623961; x= 1720710361; bh=xr9tBqKOmlXpCPcuz5ZbYj9AIqCjpTd4UzRRBXR/aJQ=; b=I dldoMyvA2e+mrnHx/IHnym8EYb7TNyythVi4A2+2ut4l/8Sei5srAfUKGUOlmU3X zOjoSWaptggFIo+0IWl6v2+Kn0+4OP/UC2rLx1Gcv9BdRTnx17y2Pq5vCl5aUgZ4 jwNl+nVJn7AWLl3XXN2ITF143LkcALEzy6bip6NRQYdUM1gVeUmHeTPOmAL5xRIG tWZsygePpW0IyDywHayr4wHyTewA54IAQeMS54vM/zbBo5Au+HLxoMeU0JV3/H3p IsVxBxmtFLTKTX2krqTCYgSLtn8Dqq1xwdMrK8uzeXzhcYRPzNy7PZukCI8nkW/e 4AzNVcdKVg9VHQWA19v4w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrfedvgddvgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgr nhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh eqnecuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieeljeeitedtjeehudegfeelkedv leekhedtgfeiffefkedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 10 Jul 2024 11:06:00 -0400 (EDT) Message-ID: Date: Wed, 10 Jul 2024 08:05:59 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Finding error in long input file To: Rich Shepard , pgsql-general@postgresql.org References: <71cf3e97-a0a5-4a94-add8-989cd1e2311d@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: 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 7/10/24 05:30, Rich Shepard wrote: > On Tue, 9 Jul 2024, Adrian Klaver wrote: > >> The error: >> >> LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636') >> >> is giving you the line number and the data: >> a) Navigate to that line number using whatever method Joe has for that. >> b) Search for '85250 Red House Rd'. > > Adrian, > > With the semicolon at the end of the line it's the last line in the file. True, I was fixated on the line number. > That's why I asked for help in finding where, in all the lines above it, > the > actual error is located. > > FWIW, I use emacs, not vim. > > I'll try inserting the data a few lines at a time, each in a transaction. If it where me I would make the data a CSV file and use \copy. That is an all or none operation and you would get a error message showing you where in the file the operation failed. > > Thanks, > > Rich > > -- Adrian Klaver adrian.klaver@aklaver.com