Postings by Georgy Pruss

RE: psqlODBC 10.01.0000 Released -- what about 9.6.6?


I can see that the 09.06.0500 driver disappeared from <a href="" title=""></a>
Will it be back? Will there be an update for PostgreSQL 9.6.6?

error with $ in names again


I think there’s still a bug in parsing names with dollars.

Linux RHEL66


create table T$001 (…) ok

create table T_$001 (…) ok


create table T$001 (…) ok

create table T_$001 (…) error

Here is session log for that:

$ test_odbc 0 'T$001'

Connection: DSN=PGDriver;UseServerSidePrepare=0

Returned connection string was: …;UseDeclareFetch=0;…;Parse=0;…;UseServerSidePrepare=1;LowerCaseIdentifier=0;

Exec: create table T$001 (i integer)


$ test_odbc 1 'T$001'

Connection: DSN=PGDriver;UseServer

ODBC for Linux/RHEL - no 9.6.5 binary build yet?


I’ve been checking <a href="" title=""></a>

and while many components were updated to 9.6.5, the latest ODBC is still


Any plans for updating it?

Thank you.

Georgiy Pruss

Bug in PostgreSQL ODBC - in names with dollar


I’m sorry, I really tried to register at pgsql-odbc list at, using different email addresses, but it didn’t’ work.

I saw that you may deal with this problem.

When UseServerSidePrepare is set to 1 (which is default, I guess), any names with $ in them cause error:

“The # of binded parameters < the # of parameter markers”

It’s both on Windows and Linux.

It seems that PG tries to use un-paired ‘$’ symbols as parameter marks for the server-side prepare/execute feature, even if there’s no PREPARE or EXECUTE statements.

I believe, PG should not par