Re: stored function, multiple queries, best practices

Lists: pgsql-jdbc
From: "Guy Rouillier" <guyr(at)masergy(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: stored function, multiple queries, best practices
Date: 2006-04-18 20:19:16
Message-ID: CC1CF380F4D70844B01D45982E671B230137A89F@mtxexch01.add0.masergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

Ash Grove wrote:

> I can only call one function (from the application)
> per transaction, right?

Incorrect. Transactions are delimited by commits or rollbacks, not by
function calls or SQL statements (more correctly, DML.) If you want to
control your commit points, tell JDBC to "conn.setAutocommit(false)".

--
Guy Rouillier