Re: commit/rollback in postgre 8.2

On 09/03/2009 10:34, Ashish Karalkar wrote:
> IPS wrote:
>> Is it possible to use begin, commit and rollback commands within a
>> transaction block in SQL function in postgre ver 8.2
>
> I guess you can use nested blocks in side a function(BEGIN,END) but not
> commit because a SQL function runs as a single transaction.

He could use SAVEPOINT to do something similar -

http://www.postgresql.org/docs/8.2/static/sql-savepoint.html

- though it might or might not work for him, depending on his needs.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------