Home > mailing lists

commit inside a function failing - Mailing list pgsql-sql

From	Suresh Raja
Subject	commit inside a function failing
Date	January 23, 2015 22:57:00
Msg-id	CAJP7dtA41j212Q48eRGoJa6_yb6YnRXj_kEth=N-0cPOgWe8fQ@mail.gmail.com Whole thread Raw
Responses	Re: commit inside a function failing (Pavel Stehule <pavel.stehule@gmail.com>) Re: commit inside a function failing (Adrian Klaver <adrian.klaver@aklaver.com>) Re: commit inside a function failing ("ktm@rice.edu" <ktm@rice.edu>)
List	pgsql-sql

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

From: Dmitry Teslenko
Date: 16 January 2015, 13:07:48
Subject: fifo stock calculation with window function

From: Pavel Stehule
Date: 23 January 2015, 23:01:45
Subject: Re: commit inside a function failing