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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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