Re: [ psqlodbc-Bugs-1000476 ] DateStyle and Transaction

Probably, this driver version is working correctly already.
There was no such "COMMIT" in my 08.01.0102 version.
I'll try to check last driver version against all my bugs.
Thanks.

--
Eugene Fokin
SOLVO Ltd.


-----Original Message-----
From: Ludek Finstrle [mailto:luf@pzkagis.cz]
Sent: Monday, December 19, 2005 11:05 PM
To: Eugene Fokin
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] [ psqlodbc-Bugs-1000476 ] DateStyle and Transaction

> I have PostgreSQL version 7.4.5.
> Also, I have "UseDeclareFetch=1" option.
> Try to turn it on, and I think you'll see BEGIN before "select
> version()".

I turn UseDeclareFetch on and I see nothing wrong in mylog:
2005-12-19 22:00:07 LOG:  autovacuum: processing database "postgres"
2005-12-19 22:00:23 LOG:  statement: BEGIN
2005-12-19 22:00:23 LOG:  statement: declare SQL_CUR00CD19A0 cursor for
select version()
2005-12-19 22:00:24 LOG:  statement: fetch 10 in SQL_CUR00CD19A0
2005-12-19 22:00:24 LOG:  statement: close SQL_CUR00CD19A0

>>> 2005-12-19 22:00:24 LOG:  statement: COMMIT

2005-12-19 22:00:24 LOG:  statement: set DateStyle to 'ISO'
2005-12-19 22:00:24 LOG:  statement: set geqo to 'OFF'
2005-12-19 22:00:24 LOG:  statement: set extra_float_digits to 2
2005-12-19 22:00:24 LOG:  statement: BEGIN
2005-12-19 22:00:24 LOG:  statement: declare SQL_CUR00CD10E0 cursor for
select oid from pg_type where typname='lo'
2005-12-19 22:00:24 LOG:  statement: fetch 10 in SQL_CUR00CD10E0
2005-12-19 22:00:24 LOG:  statement: close SQL_CUR00CD10E0
2005-12-19 22:00:24 LOG:  statement: COMMIT
2005-12-19 22:00:24 LOG:  statement: select pg_client_encoding()
2005-12-19 22:00:24 LOG:  statement: set client_encoding to 'WIN1250'
2005-12-19 22:00:47 LOG:  statement: BEGIN
2005-12-19 22:00:47 LOG:  statement: declare SQL_CUR00CD10E0 cursor for
select nothing from notable
2005-12-19 22:00:47 ERROR:  relation "notable" does not exist
2005-12-19 22:00:47 LOG:  statement: ROLLBACK

Are you sure you use autocommit? Please could you post your mylog
and pgsql log?

Regards,

Luf