pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Craig Ringer <craig@postnewspapers.com.au>
To: luke.78@libero.it <luke.78@libero.it>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Problem commit in function
Date: Mon, 07 Apr 2008 21:36:38 +0800
Message-ID: <47FA2366.8010902@postnewspapers.com.au> (raw)
In-Reply-To: <JYYG3F$987AB0A541D783E71C50559CF6747664@libero.it>
References: <JYYG3F$987AB0A541D783E71C50559CF6747664@libero.it>

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



view thread (3+ messages)

Message-ID: <47FA2366.8010902@postnewspapers.com.au>
Permalink:  ../47FA2366.8010902@postnewspapers.com.au/
Also on:    postgresql.org/message-id/47FA2366.8010902@postnewspapers.com.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: craig@postnewspapers.com.au, luke.78@libero.it
  Subject: Re: Problem commit in function
  In-Reply-To: <47FA2366.8010902@postnewspapers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox