Re: sql insert function

From: "Chris Ochs" <chris(at)paymentonline(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: sql insert function
Date: 2004-01-13 01:09:10
Message-ID: 027a01c3d971$d9be3900$250a8b0a@chris
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thapliyal, Deepak 2004-01-13 01:24:14 Re: Parse error help needed...
Previous Message Alex Satrapa 2004-01-13 00:56:54 Re: Parse error help needed...