MIME-Version: 1.0
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>
 <f22f17ee-1f8c-b98c-1ee4-d01d36cf925@appl-ecosys.com>
In-Reply-To: <f22f17ee-1f8c-b98c-1ee4-d01d36cf925@appl-ecosys.com>
From: Hans Schou <hans.schou@gmail.com>
Date: Wed, 10 Jul 2024 15:01:13 +0200
Message-ID: <CAApBw36wX-00eWZDe3bEmYx0DjEdJ-xVGv=Hs4YpM13f51U-Sg@mail.gmail.com>
Subject: Re: Finding error in long input file
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a544d2061ce43e20"
Archived-At: <https://www.postgresql.org/message-id/CAApBw36wX-00eWZDe3bEmYx0DjEdJ-xVGv%3DHs4YpM13f51U-Sg%40mail.gmail.com>
Precedence: bulk

--000000000000a544d2061ce43e20
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

If the file has these line breaks you show, then can make it to multiple
'INSERT INTO' instead.

Search for lines starting with parentese begin '(' and replace it with the
correct INSERT and last comma to semi-colon:
  cat i.sql | sed -e 's/^(/INSERT INTO foo VALUES(/' -e 's/,$/;/'

Does the file come from mysqldump? Then try option --extended-insert=3DFALS=
E

On Wed, Jul 10, 2024 at 2:53=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> On Tue, 9 Jul 2024, Craig McIlwee wrote:
>
> > The input file is 488 lines (presumably, since Rich said the file shoul=
d
> > 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 =
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, et al.,
>
> I use emacs for scripts and coding, joe's only for small jobs.
>
> I added a line to the file so the bottom line is now 489. The attached
> image
> shows that line is the only one terminated with a semicolon rather than a
> comma.
>
> psql would tell me if there was no closing parenthesis on a line, if the
> terminating comma was missing, or other similar error, and would tell me
> the
> number of the line or following line. Having the error marked at the end =
of
> the file does not tell _me_ just where the error actually is.
>
> Partial screenshot attached.
>
> Thanks all,
>
> Rich


--=20
=F0=9D=95=B3=F0=9D=96=86=F0=9D=96=93=F0=9D=96=98 =F0=9D=95=BE=F0=9D=96=88=
=F0=9D=96=8D=F0=9D=96=94=F0=9D=96=9A
=E2=98=8F =E2=9E=81=E2=9E=81 =E2=9E=85=E2=9E=83 =E2=9E=87=E2=93=AA =E2=9E=
=81=E2=93=AA

--000000000000a544d2061ce43e20
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>If the file has these line breaks you show, then can =
make it to multiple &#39;INSERT INTO&#39; instead.</div><div><br></div><div=
>Search for lines starting with parentese begin &#39;(&#39; and replace it =
with the correct INSERT and last comma to semi-colon:</div><div>=C2=A0 cat =
i.sql | sed -e &#39;s/^(/INSERT INTO foo VALUES(/&#39; -e &#39;s/,$/;/&#39;=
</div><div><br></div><div>Does the file come from mysqldump? Then try optio=
n <code class=3D"gmail-hljs gmail-language-sql"><span class=3D"gmail-hljs-c=
omment">--extended-insert=3DFALSE </span></code></div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Jul 10, 2024=
 at 2:53=E2=80=AFPM Rich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys=
.com">rshepard@appl-ecosys.com</a>&gt; wrote:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex">On Tue, 9 Jul 2024, Craig McIlwee wrote:<br>
<br>
&gt; The input file is 488 lines (presumably, since Rich said the file shou=
ld<br>
&gt; insert 488 rows). It seems like too much of a coincidence that the las=
t<br>
&gt; character of the last line is really the error. My guess is that there=
 is<br>
&gt; an unmatched character, perhaps a parenthesis, that is throwing off th=
e<br>
&gt; parser because it doesn&#39;t expect the statement to terminate yet. M=
aybe<br>
&gt; that unmatched char really is on the last line, but &#39;85250 Red Hou=
se Rd&#39;<br>
&gt; doesn&#39;t seem like the issue. I don&#39;t know anything about the j=
oe editor,<br>
&gt; but I&#39;d hope that any decent editor with syntax highlighting would=
 make it<br>
&gt; apparent where things went awry.<br>
<br>
Craig, et al.,<br>
<br>
I use emacs for scripts and coding, joe&#39;s only for small jobs.<br>
<br>
I added a line to the file so the bottom line is now 489. The attached imag=
e<br>
shows that line is the only one terminated with a semicolon rather than a<b=
r>
comma.<br>
<br>
psql would tell me if there was no closing parenthesis on a line, if the<br=
>
terminating comma was missing, or other similar error, and would tell me th=
e<br>
number of the line or following line. Having the error marked at the end of=
<br>
the file does not tell _me_ just where the error actually is.<br>
<br>
Partial screenshot attached.<br>
<br>
Thanks all,<br>
<br>
Rich</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature=
_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=
=3D"ltr"><div><div dir=3D"ltr"><div>=F0=9D=95=B3=F0=9D=96=86=F0=9D=96=93=F0=
=9D=96=98=C2=A0=F0=9D=95=BE=F0=9D=96=88=F0=9D=96=8D=F0=9D=96=94=F0=9D=96=9A=
<br></div><div>=E2=98=8F =E2=9E=81=E2=9E=81 =E2=9E=85=E2=9E=83 =E2=9E=87=E2=
=93=AA =E2=9E=81=E2=93=AA<br></div></div></div></div></div>

--000000000000a544d2061ce43e20--