Re: [GENERAL] commit/rollback in postgre 8.2

2009-03-09 Thread Grzegorz Jaśkiewicz
On Mon, Mar 9, 2009 at 8:25 AM, IPS 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

Re: [GENERAL] commit/rollback in postgre 8.2

2009-03-09 Thread Raymond O'Donnell
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 ru

Re: [GENERAL] commit/rollback in postgre 8.2

2009-03-09 Thread Ashish Karalkar
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 transa

[GENERAL] commit/rollback in postgre 8.2

2009-03-09 Thread IPS
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