Thread: commit inside a function failing

On 01/23/2015 11:56 AM, Suresh Raja wrote:
> Hi All:
>
> We are running a function with a loop in it. We tried
> commit;
> We are getting error with above command.   How can i easily commit
> withing a function.

Functions do not have transactions inside them. If you are using plpgsql
you can use EXCEPTIONS:

http://www.postgresql.org/docs/9.3/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
>
>
> Thanks,
> -SR


--
Adrian Klaver
adrian.klaver@aklaver.com

On Fri, Jan 23, 2015 at 01:56:53PM -0600, Suresh Raja wrote:
> Hi All:
>
> We are running a function with a loop in it. We tried
> commit;
> We are getting error with above command.   How can i easily commit withing
> a function.
>
>
> Thanks,
> -SR

PostgreSQL functions run within a transaction. You would need to use
something like db_link.

Regards,
Ken

<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.