Re: problem with transactions in VB.NET using npgsql

From: Owen Hartnett <owen(at)clipboardinc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with transactions in VB.NET using npgsql
Date: 2007-08-28 14:14:03
Message-ID: p06230904c2f9de183e5a@[192.168.0.102]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 7:05 PM -0400 8/27/07, Tom Lane wrote:
>Owen Hartnett <owen(at)clipboardinc(dot)com> writes:
>> I assign the transaction object to each of the commands, but it seems
>> that some tables will get updated, even when I call rollback. Is
>> something I'm calling secretly calling "commit" somewhere?
>
>Dunno anything about vb.net, but this sounds like an autocommit feature
>that's not doing what you expect.
>
>If nothing else comes to mind, try setting the DB to log all statements
>(see log_statement), and compare the resulting trace to what you think
>your code is doing. That should at least narrow it down a lot.
>
> regards, tom lane

Thanks, I'll give that a try.

-Owen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-08-28 14:21:02 Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)
Previous Message Keaton Adams 2007-08-28 14:07:12 Turning off atime on PostgreSQL DB volumes