Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Finding error in long input file
From: Alban Hertroys <haramrae@gmail.com>
In-Reply-To: <155fc2ec-d936-4838-b4dd-ca7d06acb6a1@aklaver.com>
Date: Wed, 10 Jul 2024 08:57:52 +0200
Cc: Craig McIlwee <craigm@vt.edu>,
 Rich Shepard <rshepard@appl-ecosys.com>,
 pgsql-general@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <C59A0E87-41F5-496D-8C61-F2B6D6D78786@gmail.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>
 <CAGqBcTavtJS36PnuYs1yHHH2f6kM79NVhKiOcnn5orYNXJawxQ@mail.gmail.com>
 <155fc2ec-d936-4838-b4dd-ca7d06acb6a1@aklaver.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/C59A0E87-41F5-496D-8C61-F2B6D6D78786%40gmail.com>
Precedence: bulk


> On 10 Jul 2024, at 06:58, Adrian Klaver <adrian.klaver@aklaver.com> =
wrote:
>=20
> On 7/9/24 17:46, Craig McIlwee wrote:
>> Full error message from earlier in the thread:
>> > psql:scripts/insert-addrs.sql:488: ERROR:  syntax error at or near =
";"
>> > LINE 488: ...2832,1,default,'85250 Red House =
Rd','Paisley','OR','97636');
>> >                                                                     =
      ^
>>    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'.
>> The input file is 488 lines (presumably, since Rich said the file =
should insert 488 rows).  It seems like too much of a coincidence that =
the last character of the last line is really the error.  My guess is =
that there=20
>=20
> This assumes that there where only INSERT lines and that each INSERT =
was only one line. I have bit by those assumptions before, hence my =
suggestion to actually find line 488.
>=20
>> is an unmatched character, perhaps a parenthesis, that is throwing =
off the parser because it doesn't expect the statement to terminate yet. =
 Maybe that unmatched char really is on the last line, but '85250 Red =
House Rd' doesn't seem like the issue.  I don't know anything about the =
joe editor, but I'd hope that any decent editor with syntax highlighting =
would make it apparent where things went awry.
>> Craig
>=20

Is this a single INSERT statement with multiple tuples after VALUES? =
Then perhaps an earlier line (my bet would be on line 487) accidentally =
ends with a semi-colon instead of a comma?

Something like this:

INSERT INTO table (col1, col2, ..., coln) VALUES
(..., ..., ),
(..., ..., ),
(..., ..., ); -- <-- This terminates the INSERT
(..., ..., ); -- <-- Now this line make no sense


Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.