[ psqlodbc-Bugs-1000476 ] DateStyle and Transaction

Bugs item #1000476, was opened at 2005-12-08 16:43
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000476&group_id=1000125

Category: None
Group: None
Status: Open
>Resolution: Accepted
Priority: 3
Submitted By: Nobody (None)
>Assigned to: Ludek Finstrle (luf)
Summary: DateStyle and Transaction

Initial Comment:
When I work with auto_commit mode off, I can issue ODBC rollback command after my first statements. After that driver
loseshis DateStyle ISO setting which one driver setup at begin. 
So, later it will return date fields in wrong format if my default database style is different then ISO (I'm using
European,SQLformat). 
Here is example attached. Gzipped TAR archive includes mylog file and postgresql log file.

I'm using Linux with unixODBC 2.2.9, psqlodbc 08.01.0102 with options "Threading=0, UseDeclareFetch=1". In application,
I'veturned auto_commit mode off. 

P.S. The same thing we'll see if we cancel first select statement. After cancellation there will be "ROLLBACK" command
whichdrops DateStyle setting too. What I think, driver should issue "COMMIT" right after settings in connection
procedure.For example, call CC_commit() at the end of CC_send_settings() function. 

----------------------------------------------------------------------

>Comment By: Ludek Finstrle (luf)
Date: 2005-12-09 03:35

Message:
I fix the problem. Patch is attached. Please try it and report if it helps.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000476&group_id=1000125