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

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