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@xxxxxxxxxxx
