Francesco Storti wrote:
> 2008/1/17, Tom Lane tgl(at)sss(dot)pgh(dot)pa(dot)us <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
>
> Should work. Maybe you're rolling back the transaction later, or
> something like that?
>
> regards, tom lane
>
>
>
> Thank for the answer first ;)
> I use rollback only if throwed an SQL exception.
You never call commit() so the transaction will be rolled back when you
close the connection. (I'm assuming you have autocommit off, you didn't
include your connection setup code)
-O