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@xxxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
