[ 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: Closed
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-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 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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

> You can respond by visiting:
> http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10004 76&group_id=1000125
> Category: None
> Group: None
> >Status: Closed

Are you sure Dave about close this bug? I don't think so.
See this thread about the topic:
http://archives.postgresql.org/pgsql-odbc/2005-12/msg00114.p hp

Do you think it's good idea to do explicit begin, commit around
connect settings all the time? I don't have time for test
this behaviour yet.

Luf

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly