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

[Ludek Finstrle <luf(at)pzkagis(dot)cz>]

> I saw in the PostgreSQL log file, either in auto_commit mode on,
> psqlodbc generates implicit transaction for each "data change statement"
> and implicit transaction for whole bunch of consequent "select
> statmenets".

It's strange. Isn't it some misunderstanding? I try it here now and
I see no start transaction in PgSQL log file. I have PgSQL 8.1 on Win32
and psqlodbc 8.01.0105 (I think it doesn't matter which 8.1 version).
What versions do you have?

> So, it starts transaction at begin and doesn't close it before first
> "data change statement". If I'll cancel one of first select, I'll lose
> DateStyle.

My PgSQL log:

2005-12-18 22:02:30 LOG:  autovacuum: processing database "postgres"
2005-12-18 22:03:05 LOG:  statement: select version()
2005-12-18 22:03:05 LOG:  statement: set DateStyle to 'ISO'
2005-12-18 22:03:05 LOG:  statement: set geqo to 'OFF'
2005-12-18 22:03:05 LOG:  statement: set extra_float_digits to 2
2005-12-18 22:03:05 LOG:  statement: select oid from pg_type where typname='lo'
2005-12-18 22:03:06 LOG:  statement: select pg_client_encoding()
2005-12-18 22:03:06 LOG:  statement: set client_encoding to 'WIN1250'
2005-12-18 22:03:18 LOG:  statement: select nothing from notable
2005-12-18 22:03:18 ERROR:  relation "notable" does not exist
2005-12-18 22:03:27 LOG:  statement: rollback
2005-12-18 22:03:27 WARNING:  there is no transaction in progress

Regards,

Luf