Re: [SQL] commit inside a function failing

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>, postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] commit inside a function failing
Date: 2015-01-23 20:00:56
Message-ID: CAFj8pRCF=874RVXHa2P486af+a5ZuckSDDjeQ_k8o93QQV7bPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Hi

2015-01-23 20:56 GMT+01:00 Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>:

> 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.
>
>
It is not possible in PostgreSQL

Regards

Pavel Stehule

>
> Thanks,
> -SR
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-01-23 20:04:17 Re: commit inside a function failing
Previous Message Suresh Raja 2015-01-23 19:56:53 commit inside a function failing

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2015-01-23 20:04:17 Re: commit inside a function failing
Previous Message Suresh Raja 2015-01-23 19:56:53 commit inside a function failing