Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id D16942E0048
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Mon,  7 Apr 2008 10:37:00 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 45133-02
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Mon,  7 Apr 2008 10:36:45 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from www.postnewspapers.com.au (www.postnewspapers.com.au
	[202.61.230.242])
	by developer.postgresql.org (Postfix) with ESMTP id 8EFCD2E004F
	for <pgsql-sql@postgresql.org>; Mon,  7 Apr 2008 10:36:52 -0300 (ADT)
Received: from mail.postnewspapers.com.au
	(202-89-185-120.static.dsl.amnet.net.au [202.89.185.120])
	by www.postnewspapers.com.au (Postfix) with ESMTP id DC3F9D55FE;
	Mon,  7 Apr 2008 21:36:45 +0800 (WST)
Received: from localhost (access [127.0.0.1])
	by mail.postnewspapers.com.au (Postfix) with ESMTP id 09DA01E0435;
	Mon,  7 Apr 2008 21:36:48 +0800 (WST)
X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au
Received: from mail.postnewspapers.com.au ([127.0.0.1])
	by localhost (access.postnewspapers.com.au [127.0.0.1]) (amavisd-new,
	port 10024)
	with LMTP id ZWNjE-UArRwe; Mon,  7 Apr 2008 21:36:47 +0800 (WST)
Received: from [203.161.97.213] (203.161.97.213.static.amnet.net.au
	[203.161.97.213])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(Client CN "Craig Ringer",
	Issuer "POST Certificate Authority" (verified OK))
	by mail.postnewspapers.com.au (Postfix) with ESMTP id F208E1E0434;
	Mon,  7 Apr 2008 21:36:46 +0800 (WST)
Message-ID: <47FA2366.8010902@postnewspapers.com.au>
Date: Mon, 07 Apr 2008 21:36:38 +0800
From: Craig Ringer <craig@postnewspapers.com.au>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: "luke.78@libero.it" <luke.78@libero.it>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Problem commit in function
References: <JYYG3F$987AB0A541D783E71C50559CF6747664@libero.it>
In-Reply-To: <JYYG3F$987AB0A541D783E71C50559CF6747664@libero.it>
X-Enigmail-Version: 0.95.6
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/43
X-Sequence-Number: 30582

luke.78@libero.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