Re: sql insert function

Chris Ochs wrote:
> My program starts a transaction, does about 20 inserts, then commits. When
> I replace once of the inserts with a function that does the insert, when I
> do the commit I get this message:
>
> WARNING: there is no transaction in progress
>
> The inserts all commit fine. Do functions used through DBD::Pg do something
> like turn on autocommit after a function is called?

Is your function calling 'commit' itself? If so, it could be committing
before your SQL statement issues the 'commit', thus attempting to commit
a transaction which doesn't exist any more.

DBD::Pg defaults to "AutoCommit" behaviour, unless you explicitly turn
it off:

my $dbh = DBI->connect (
"DBI:Pg:dbname=database", "user" , "password",
{AutoCommit => 0}
);

HTH
Alex Satrapa