Problems with AutoCommit ...

Hi All,

I am having problem in using AutoCommit...

The Environment:
~~~~~~~~~~~~~~~~

Slackware Linux 2.2.6
Perl 5.005_02
Postgres 6.5.1
DBI 1.13
DBD-Pg-0.92

The Connection Code:
~~~~~~~~~~~~~~~~~~~

($DBCONN = DBI->connect("dbi:Pg:dbname=$DBNAME;
host=$DBHOST;
port=$DBPORT",
$DBUSER,
$DBPASS,
{PrintError => 0, AutoCommit=>0}))
or (&GlobalErrorSet(-1)) ;

The Problem :
~~~~~~~~~~~~~
If the AutoCommit value is SET to '0' , The Database query is
failing after 2 or 3 SELECT queries are executed succefully.
Also, UPDATE, INSERT, and DELETE are failing.

If AutoCommit is SET to '1', Then all queries WORKS fine.

Solution Expected:
~~~~~~~~~~~~~~~~~~
1. Solution for the above problem
2. A way to use 'Commit' and 'Rollback' facility in Postgres database
with perl
3. Does DBI supports procedures? If so, how can we do it?

Expecting a favarouble reply

Thanks in Advance
Shadkam