[ psqlodbc-Bugs-1000476 ] DateStyle and Transaction

Bugs item #1000476, was opened at 2005-12-08 15:43
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10004 76&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 loses his 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,SQL format).
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've turned 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 which drops 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: Dave Page (dpage)
Date: 2005-12-10 16:17

Message:
Bug re-opened - Luf pointed out some ongoing discussion about whether the fix is 100% right or not.

http://archives.postgresql.org/pgsql-odbc/2005-12/msg00114.p hp

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

Comment By: Dave Page (dpage)
Date: 2005-12-09 22:59

Message:
Patch applied, thanks.

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

Comment By: Ludek Finstrle (luf)
Date: 2005-12-09 02: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=10004 76&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings