Re: Finding error in long input file
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2024-07-10T12:30:59Z
Lists: pgsql-general
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