Re: Problem commit in function

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
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 13:36:38
Message-ID: 47FA2366.8010902@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

luke(dot)78(at)libero(dot)it wrote:
> Hi,
> I need to execute COMMIT in a function pgsql,
> there is a way?
>
A function runs in a transaction. It cannot, as far as I know, commit one.

Why do you need to do that, anyway? What're you trying to achieve?

--
Craig Ringer

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2008-04-07 13:38:51 Re: Commit every processed record
Previous Message Gerardo Herzig 2008-04-07 13:04:31 Re: how to returns set of records in PL/python