Postgres Pro
Downloads
Home   >   mailing lists

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

From Craig Ringer
Subject Re: Problem commit in function
Date
Msg-id 47FA2366.8010902@postnewspapers.com.au
Whole thread Raw
In response to Problem commit in function  ("luke\.78\@libero\.it" <luke.78@libero.it>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: Re: how to returns set of records in PL/python
Next
From: Craig Ringer
Date:
Subject: Re: Commit every processed record