Thread: Problem commit in function

Hi,
I need to execute COMMIT in a function pgsql,
there is a way?
Can I have any example?

Thanks in advance.

Luke.

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

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