BUG #19394: error in ecpg
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
On Thursday, February 5, 2026, PG Bug reporting form <noreply@postgresql.org>
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’d have expected
both to require quoting.
David J.