View Single Post

   
  #2 (permalink)  
Old 04-19-2008, 06:01 PM
Pavan Deolasee
 
Posts: n/a
Default Re: Problem commit in function

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply With Quote