FYI..I use the postgres8.1.404 jdbc driver

-----Original Message-----
From: Oliver Jowett [mailtoliver@opencloud.com]
Sent: Thursday, September 28, 2006 3:24 PM
To: Sriram Dandapani
Cc: pgsql-jdbc@postgresql.org; pgsql-admin@postgresql.org
Subject: Re: [JDBC] number of transactions doubling

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)
>
> I expect JDBC Batching to generate fewer transactions depending on
> batch size.

Have you turned autocommit off?

-O

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match