Chris Pesko writes:
> Can I put transactions and cursors into functions? 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?
Pg doesn't supported nested transactions or save points (yet
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
Can I put transactions and cursors into functions? 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?
---(end of broadcast)---
TIP 3: if po