Re: [SQL] Problem while using start transaction ans commit;

On Mon, 2005-10-17 at 12:53 +0530, Sri wrote: > Hi All, > > I have a small problem in using nested transactions while working on > Postgres 8.0. > > Ex: I have a function A() which in turn calls functions b() and c() , > if i want commit something in b or c. i have to use You cannot start or

Re: [SQL] Problem while using start transaction ans commit;

Sri, > I have a small problem in using nested transactions while > working on Postgres 8.0. This is a known problem with Postgres 8.0 - there is no support for nested transactions (which occurs when calling functions). Your best bet would be to raise an exception within B or C - this will cause

[SQL] Problem while using start transaction ans commit;

Hi All,   I have a small problem in using nested transactions while working on Postgres 8.0.   Ex: I have a function A() which in turn calls functions b() and c() , if i want commit something in b or c. i have to use   start transaction read write; -- set of sql statements and then say com