DevHeads.net

Postings by Georgy Pruss

error with $ in names again

Hi,

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

Linux RHEL66

UseServerSidePrepare=0:

create table T$001 (…) ok

create table T_$001 (…) ok

UseServerSidePrepare=1:

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)

ok

$ test_odbc 1 'T$001'

Connection: DSN=PGDriver;UseServer

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

Hi,

I’ve been checking <a href="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/" title="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/">https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/</a>

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

postgresql96-odbc-09.06.0410-1PGDG.rhel6.x86_64.rpm.

Any plans for updating it?

Thank you.

Georgiy Pruss

Bug in PostgreSQL ODBC - in names with dollar

Hi,

I’m sorry, I really tried to register at pgsql-odbc list at postgresql.org, 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