Re: transactions and cursors...... - Mailing list pgsql-admin

From Dan Langille
Subject Re: transactions and cursors......
Date
Msg-id 200202272015.g1RKExk94176@lists.unixathome.org
Whole thread Raw
In response to transactions and cursors......  (Chris Pesko <cpesko@organic.com>)
List pgsql-admin
On 27 Feb 2002 at 9:30, Chris Pesko wrote:

> Can I put transactions and cursors into functions?

No.

> As soon as I put BEGIN;
> and COMMIT; wrapping an insert statement within a function, I get errors.
> Do these programs need to reside outside of the database?

AFAIK, yes.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples


pgsql-admin by date:

Previous
From: Chris Pesko
Date:
Subject: transactions and cursors......
Next
From: "Zhang, Anna"
Date:
Subject: optimizer