Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem commit in function - Mailing list pgsql-sql

From Pavan Deolasee
Subject Re: Problem commit in function
Date
Msg-id 2e78013d0804070536t8037783x5078bd0074195a09@mail.gmail.com
Whole thread Raw
In response to Problem commit in function  ("luke\.78\@libero\.it" <luke.78@libero.it>)
List pgsql-sql
Tree view 
On Mon, Apr 7, 2008 at 6:00 PM, luke.78@libero.it <luke.78@libero.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

pgsql-sql by date:

Previous
From: "luke\.78\@libero\.it"
Date:
Subject: Problem commit in function
Next
From: "luke\.78\@libero\.it"
Date:
Subject: Commit every processed record