public inbox for [email protected]  
help / color / mirror / Atom feed
BUG #19394: error in ecpg
2+ messages / 2 participants
[nested] [flat]

* BUG #19394: error in ecpg
@ 2026-02-05 14:58 PG Bug reporting form <[email protected]>
  2026-02-05 15:31 ` Re: BUG #19394: error in ecpg David G. Johnston <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2026-02-05 14:58 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

The following bug has been logged on the website:

Bug reference:      19394
Logged by:          Alexey G
Email address:      [email protected]
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 [email protected] AS con1 USER postgres;
i get error near "4"

If i set
EXEC SQL CONNECT TO [email protected] AS con1 USER postgres;
as well








^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #19394: error in ecpg
  2026-02-05 14:58 BUG #19394: error in ecpg PG Bug reporting form <[email protected]>
@ 2026-02-05 15:31 ` David G. Johnston <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: David G. Johnston @ 2026-02-05 15:31 UTC (permalink / raw)
  To: [email protected] <[email protected]>; [email protected] <[email protected]>

On Thursday, February 5, 2026, PG Bug reporting form <[email protected]>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19394
> Logged by:          Alexey G
> Email address:      [email protected]
> 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 [email protected] AS con1 USER postgres;
> i get error near "4"
>
> If i set
> EXEC SQL CONNECT TO [email protected] 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.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2026-02-05 15:31 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-02-05 14:58 BUG #19394: error in ecpg PG Bug reporting form <[email protected]>
2026-02-05 15:31 ` David G. Johnston <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox