Re: Problem commit in function

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: "luke(dot)78(at)libero(dot)it" <luke(dot)78(at)libero(dot)it>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem commit in function
Date: 2008-04-07 12:36:12
Message-ID: 2e78013d0804070536t8037783x5078bd0074195a09@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Apr 7, 2008 at 6:00 PM, luke(dot)78(at)libero(dot)it <luke(dot)78(at)libero(dot)it> wrote:
> Hi,
> I need to execute COMMIT in a function pgsql,
> there is a way?
>

No. Transaction control statements like COMMIT/ROLLBACK/SAVEPOINT
are not supported inside plpgsql functions.

If you can tell us what you are trying to do, somebody may help you
with that.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message luke.78@libero.it 2008-04-07 12:46:50 Commit every processed record
Previous Message luke.78@libero.it 2008-04-07 12:30:51 Problem commit in function