Date: Wed, 10 Jul 2024 05:30:59 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Subject: Re: Finding error in long input file
In-Reply-To: <a7fa574d-f32f-4c90-8ab2-51fec0448d89@aklaver.com>
Message-ID: <cbde8e6a-74df-60cd-db88-43134a51ac3@appl-ecosys.com>
References: <b9639830-1a9-c1fc-8444-a436b167c56c@appl-ecosys.com> <71cf3e97-a0a5-4a94-add8-989cd1e2311d@aklaver.com> <fe393542-b125-de58-6333-623ab86dbafe@appl-ecosys.com> <a7fa574d-f32f-4c90-8ab2-51fec0448d89@aklaver.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
Archived-At: <https://www.postgresql.org/message-id/cbde8e6a-74df-60cd-db88-43134a51ac3%40appl-ecosys.com>
Precedence: bulk

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.
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.

Thanks,

Rich