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.
-Owen
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly