On Sep 29, 2006, at 4:56 AM, Heikki Linnakangas wrote:
Jim C. Nasby wrote:
On Thu, Sep 28, 2006 at 02:51:24PM -0700, Sriram Dandapani wrote:
The target table has triggers that route data to appropriate
tables. The
tables to which data is routed has check constraints that do further
inserts. (All of this happens in 1 jdbc transaction)
Actually, no matter what JDBC is doing, all of that will happen
within a
single transaction on the database (unless you're using something
like
dblink from within the triggers). So even if you were issuing insert
statements with autocommit on, you'd see at most one transaction per
insert.
The triggers might use subtransactions. You get implicit
subtransactions if have an EXCEPTION clause in a plpgsql function.
I'm not sure if there's other things that do that as well.
Ahh, I thought that was handled within cmin/cmax.
--
Jim Nasby jim@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
