Thread: commit/rollback in postgre 8.2

IPS wrote:
>  Is it possible to use begin, commit and rollback commands within a
> transaction block in  SQL function in postgre ver 8.2
>
> with regards,
>
> I.P.S. Sethi
>
>
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.


With Regards
Ashish Karalkar
EnterpriseDB

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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On Mon, Mar 9, 2009 at 8:25 AM, IPS <sethi@nic.in> wrote:
>  Is it possible to use begin, commit and rollback commands within a
> transaction block in  SQL function in postgre ver 8.2

if you want to break plpgsql function, use exceptions. That will cause
transaction (which in it self is the whole procedure) to be rolled
back.

--
GJ