MIME-Version: 1.0
In-Reply-To: <19394-0997a5bdb836c074@postgresql.org>
References: <19394-0997a5bdb836c074@postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 5 Feb 2026 08:31:40 -0700
Message-ID: <CAKFQuwZ=wv1xpuQANkes3V_iyocfjqaxwOXza4Ym=NoHJePj3Q@mail.gmail.com>
Subject: Re: BUG #19394: error in ecpg
To: "alex@ilona.su" <alex@ilona.su>, 
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009ef97e064a155e85"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ%3Dwv1xpuQANkes3V_iyocfjqaxwOXza4Ym%3DNoHJePj3Q%40mail.gmail.com>
Precedence: bulk

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

On Thursday, February 5, 2026, PG Bug reporting form <noreply@postgresql.or=
g>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19394
> Logged by:          Alexey G
> Email address:      alex@ilona.su
> PostgreSQL version: Unsupported/Unknown
> Operating system:   linux
> Description:
>
> I have database 4duksh on 182.168.123.4. Postgresq 13.
>
> If i set
> EXEC SQL CONNECT TO 4duksh@192.168.123.4 AS con1 USER postgres;
> i get error near "4"
>
> If i set
> EXEC SQL CONNECT TO db4duksh@192.168.123.4 AS con1 USER postgres;
> as well
>
>
This is not a bug.  The options and limitations for writing the target are
documented here.

 https://www.postgresql.org/docs/current/ecpg-connect.html#ECPG-CONNECTING

In PostgreSQL, plain identifiers cannot begin with a number.

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-=
IDENTIFIERS

Apparently target is a bit looser in what it allows since I=E2=80=99d have =
expected
both to require quoting.

David J.

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

On Thursday, February 5, 2026, PG Bug reporting form &lt;<a href=3D"mailto:=
noreply@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex">The following bug has been logged on the website:<br>
<br>
Bug reference:=C2=A0 =C2=A0 =C2=A0 19394<br>
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Alexey G<br>
Email address:=C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:alex@ilona.su">alex@il=
ona.su</a><br>
PostgreSQL version: Unsupported/Unknown<br>
Operating system:=C2=A0 =C2=A0linux<br>
Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>
<br>
I have database 4duksh on 182.168.123.4. Postgresq 13.<br>
<br>
If i set<br>
EXEC SQL CONNECT TO <a href=3D"mailto:4duksh@192.168.123.4">4duksh@192.168.=
123.4</a> AS con1 USER postgres;<br>
i get error near &quot;4&quot;<br>
<br>
If i set<br>
EXEC SQL CONNECT TO <a href=3D"mailto:db4duksh@192.168.123.4">db4duksh@192.=
168.123.4</a> AS con1 USER postgres;<br>
as well<br><br>
</blockquote><div><br></div><div>This is not a bug.=C2=A0 The options and l=
imitations for writing the target are documented here.</div><div><br></div>=
<div>=C2=A0<a href=3D"https://www.postgresql.org/docs/current/ecpg-connect.=
html#ECPG-CONNECTING">https://www.postgresql.org/docs/current/ecpg-connect.=
html#ECPG-CONNECTING</a></div><div><br></div><div>In PostgreSQL, plain iden=
tifiers cannot begin with a number.</div><div><br></div><div><a href=3D"htt=
ps://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDE=
NTIFIERS">https://www.postgresql.org/docs/current/sql-syntax-lexical.html#S=
QL-SYNTAX-IDENTIFIERS</a><br></div><div><br></div><div>Apparently target is=
 a bit looser in what it allows since I=E2=80=99d have expected both to req=
uire quoting.</div><div><br></div><div>David J.</div><div><br></div><div><b=
r></div>

--0000000000009ef97e064a155e85--