Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem while using start transaction ans commit; - Mailing list pgsql-sql

From Oliver Elphick
Subject Re: Problem while using start transaction ans commit;
Date
Msg-id 1129707933.19925.5.camel@linda.lfix.co.uk
Whole thread Raw
In response to Problem while using start transaction ans commit;  ("Sri" <asrinivas@effigent.net>)
List pgsql-sql
Tree view 
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 commit a transaction inside a function.  You can use
savepoints.

-- 
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
======================================== Do you want to know God?   http://www.lfix.co.uk/knowing_god.html

pgsql-sql by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Query information needed
Next
From: Mario Splivalo
Date:
Subject: Field Separator not working?