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-09-05 14:35:15 |
Message-ID: | p06230903c3046ed638b2@[192.168.2.176] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
At 10:14 AM -0400 8/28/07, Owen Hartnett wrote:
>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.
>
I've been able to turn on statement logging (I've set log_statement
to 'all'), but it doesn't seem to show the begin transaction - commit
- rollback statements. Is there another way to have them show up in
the log?
-Owen
From | Date | Subject | |
---|---|---|---|
Next Message | Håkan Jacobsson | 2007-09-05 14:35:56 | SQL for Deleting all duplicate entries |
Previous Message | SHARMILA JOTHIRAJAH | 2007-09-05 14:27:36 | how to find the number of rows inserted into the master table? |