MIME-Version: 1.0
References: <9c84776d-d938-9fa4-ab1-6ee960ce6e7d@appl-ecosys.com>
 <7ec33517-6dc1-4e1d-b741-0c26eba7cc79@aklaver.com> <bb74e92e-1cf-1f7e-eeaa-44ce4162f7fd@appl-ecosys.com>
 <ce828b41-3e25-4f68-aed2-397fddff8849@aklaver.com>
In-Reply-To: <ce828b41-3e25-4f68-aed2-397fddff8849@aklaver.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 14 Jul 2025 12:56:16 -0700
Message-ID: <CAKFQuwasMXtnE1knadTpzTn_yF3g=PoG4KSdds_iXxB7sMLbhg@mail.gmail.com>
Subject: Re: Syntax error needs explanation
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Rich Shepard <rshepard@appl-ecosys.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a7c80f0639e90f4c"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwasMXtnE1knadTpzTn_yF3g%3DPoG4KSdds_iXxB7sMLbhg%40mail.gmail.com>
Precedence: bulk

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

On Mon, Jul 14, 2025 at 12:45=E2=80=AFPM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:

> >
> > I mistyped the script's extension as .txt rather than .sql.
>
> That does not matter, that is more for user convenience in figuring out
> what the files are for.
>
>
I think all that is being said is the error was a simple typo, choosing the
wrong file to execute.  Not reading the error message was the real issue,
not a failure to understand how psql scripting works.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Jul 14, 2025 at 12:45=E2=80=AFPM Adrian Klaver &lt=
;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>=
&gt; wrote:</span></div></div><div class=3D"gmail_quote gmail_quote_contain=
er"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left:1px solid rgb(204,204,204);padding-left:1ex">&gt; <br>
&gt; I mistyped the script&#39;s extension as .txt rather than .sql.<br>
<br>
That does not matter, that is more for user convenience in figuring out <br=
>
what the files are for.<br>
<br></blockquote><div><br></div><div><div class=3D"gmail_default" style=3D"=
font-family:arial,helvetica,sans-serif">I think all that is being said is t=
he error was a simple typo, choosing the wrong file to execute.=C2=A0 Not r=
eading the error message was the real issue, not a failure to understand ho=
w psql scripting works.</div></div><div class=3D"gmail_default" style=3D"fo=
nt-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default=
" style=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></d=
iv></div></div>

--000000000000a7c80f0639e90f4c--