Re: sql insert function - Mailing list pgsql-general

From Chris Ochs
Subject Re: sql insert function
Date
Msg-id 027a01c3d971$d9be3900$250a8b0a@chris
Whole thread Raw
In response to sql insert function  ("Chris Ochs" <chris@paymentonline.com>)
Responses Re: sql insert function  (Alex Satrapa <alex@lintelsys.com.au>)
List pgsql-general
I am seeing another strange thing when using a function that does an insert
instead of doing the insert directly.  This is using cached connections with
apache/mod_perl.

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?



pgsql-general by date:

Previous
From: Alex Satrapa
Date:
Subject: Re: Parse error help needed...
Next
From: "Thapliyal, Deepak"
Date:
Subject: Re: Parse error help needed...