Re: transactions and cursors......

From: "Dan Langille" <dan(at)langille(dot)org>
To: Chris Pesko <cpesko(at)organic(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: transactions and cursors......
Date: 2002-02-27 20:14:55
Message-ID: 200202272015.g1RKExk94176@lists.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Zhang, Anna 2002-02-27 21:01:19 optimizer
Previous Message Craig Moon 2002-02-27 17:52:29 Re: Client Authentication