Re: commit/rollback in postgre 8.2

From: Ashish Karalkar <ashish(dot)karalkar(at)enterprisedb(dot)com>
To: IPS <sethi(at)nic(dot)in>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: commit/rollback in postgre 8.2
Date: 2009-03-09 10:34:05
Message-ID: 49B4F09D.1080000@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Schröder 2009-03-09 10:45:38 Re: Performance of subselects
Previous Message Kaloyan Iliev 2009-03-09 10:25:05 Re: Problem with encoding conversions