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

Re: Savepoints in ODBC driver

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Cc: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Subject: Re: Savepoints in ODBC driver
Date: 2009-08-19 08:11:02
Message-ID: 1135091251.20090819101102@munnin.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello Richard,

Tuesday, August 18, 2009, 11:26:49 PM, you wrote:

RB> On Tue, Aug 18, 2009 at 12:45 PM, Rainer Bauer<usenet(at)munnin(dot)com> wrote:

>> RB> while checking some performance bottlenecks I realized that the ODBC
>> RB> driver is creating/deleting a savepoint for *every* command send to
>> RB> the server.

RB> I can only guess.  But I would expect that your "Level of Rollback on
RB> Error" could be causing this.  You might try a different setting.

Bingo! Thanks Richard.

Rainer


In response to

pgsql-odbc by date

Next:From: Richard NeillDate: 2009-08-19 14:40:29
Subject: ODBC 64-bit driver request
Previous:From: Tom GoodmanDate: 2009-08-18 23:59:12
Subject: Problem with the read only clause for read only cursors

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