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

7.1 beta 3 Linux ODBC BEGIN Behaviour

From: Steve Wranovsky <stevew(at)merge(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: 7.1 beta 3 Linux ODBC BEGIN Behaviour
Date: 2001-02-08 19:28:57
Message-ID: 4.3.2.7.2.20010208124747.00c3e860@mail.merge.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbc
Hello,

I found another slight behavior change with the Linux
client ODBC library between 7.0.3 and the 7.1 beta 3 
release.  We are running under Redhat 6.0.

We have set the ODBC driver in autocommit off mode.  With
the 7.0.3 driver, a BEGIN was automatically issued
before the driver encountered a INSERT/UPDATE/DELETE.  With
the 7.1 beta 3 ODBC driver, it now also issues a BEGIN when it
encounters a SELECT.

Is this the expected behavior under 7.1?

Below are snipets from the psqlodbc log to show  the change.
I actually found the problem because our code does a number
of queries against the database, and then issues a 
VACUUM ANALYZE.  This stopped working with the 7.1 beta 3.

Thanks,
Steve

<lines removed>
conn=136030528, query='COMMIT'
conn=136030528, query='BEGIN'
conn=136030528, query='select count(*) from Objects'
    [ fetched 1 rows ]
conn=136030528, query='select count(*) from ExchangeQueue '
    [ fetched 1 rows ]
conn=136030528, query='vacuum analyze'
ERROR from backend during send_query: 'ERROR:  VACUUM cannot run inside a BEGIN/END block'


And, here's the same code executed under 7.0.3:

conn=136031776, query='COMMIT'
conn=136031776, query='select count(*) from Objects'
    [ fetched 1 rows ]
conn=136031776, query='select count(*) from ExchangeQueue '
    [ fetched 1 rows ]
conn=136031776, query='vacuum analyze'

**     Steve Wranovsky (stevew(at)merge(dot)com)     ** Merge Technologies Inc
**           Lead Software Engineer           ** Milwaukee, WI - USA
**     Merge is a supplier of connectivity    ** Phone: +1 (414) 977-4133
** solutions for medical imaging applications ** http://www.merge.com


Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-02-09 05:02:18
Subject: Re: 7.1 beta 3 Linux ODBC BEGIN Behaviour
Previous:From: Dave PageDate: 2001-02-08 09:57:22
Subject: RE: 7.1 beta 4 ODBC Connection Problem

pgsql-interfaces by date

Next:From: Jan WieckDate: 2001-02-08 21:56:04
Subject: Re: Re: Re: Postgres and Oracle differences and questions
Previous:From: Tom LaneDate: 2001-02-08 15:00:57
Subject: Re: Re: Re: Postgres and Oracle differences and questions

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