Skip site navigation (1) Skip section navigation (2)

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

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Eugene Fokin <elf(at)solvo(dot)ru>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ psqlodbc-Bugs-1000476 ] DateStyle and Transaction
Date: 2005-12-19 20:04:56
Message-ID: 20051219200456.GA16740@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> 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

In response to

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-19 20:07:34
Subject: Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel
Previous:From: AndrusDate: 2005-12-19 19:53:58
Subject: Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group