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