Re: commit inside a function failing - Mailing list pgsql-sql

From Christopher Browne
Subject Re: commit inside a function failing
Date
Msg-id BLU436-SMTP17078F7243A8AD8C98CC6B3B3370@phx.gbl
Whole thread Raw
In response to commit inside a function failing  (Suresh Raja <suresh.rajaabc@gmail.com>)
List pgsql-sql
<p dir="ltr">The straightforward answer is that stored functions always run *inside* the context of a preexisting
transaction,therefore you cannot request a separate transaction from within a stored function.<p dir="ltr">What you are
askingis fairly deeply impossible. 

pgsql-sql by date:

Previous
From: Jason Aleski
Date:
Subject: Re: Better way to compute moving averages?
Next
From: Suresh Raja
Date:
Subject: check if the same function is already running, then exit!