X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4731EDA730 for ; Mon, 17 Oct 2005 04:21:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75758-05 for ; Mon, 17 Oct 2005 07:20:57 +0000 (GMT) Received: from effigent.net (effigent.net [210.211.230.208]) by svr1.postgresql.org (Postfix) with ESMTP id 8C742DA72B for ; Mon, 17 Oct 2005 04:20:57 -0300 (ADT) Received: from pc23 (unknown [192.168.1.23]) by effigent.net (Postfix) with SMTP id 8CE0A52D8BE3 for ; Mon, 17 Oct 2005 12:50:59 +0530 (IST) Message-ID: From: "Sri" To: Subject: Problem while using start transaction ans commit; Date: Mon, 17 Oct 2005 12:53:04 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000F_01C5D319.B6F6FC10" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4947.1900 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4952.2800 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.065 required=5 tests=[FORGED_MUA_OUTLOOK=3.037, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: *** X-Archive-Number: 200510/189 X-Sequence-Number: 23042 This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C5D319.B6F6FC10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 =20 start transaction read write; -- set of sql statements and then say commit. commit; but this is not working it is showing the the following error near start = transaction read write=20 " ERROR: SPI_execute_plan failed executing query "start transaction = read write": SPI_ERROR_TRANSACTION "; =20 or =20 if i use only commit with out the start transaction command it throwing = the runtime error as " ERROR: SPI_execute_plan failed executing query "commit": = SPI_ERROR_TRANSACTION "; =20 Can any one send me an example of how to use the start transaction or = how to commit an nested transaction. Thanks in advance. Thanks & Regards, Sri ------=_NextPart_000_000F_01C5D319.B6F6FC10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All,
 
I have a small problem in = using nested=20 transactions while working on Postgres 8.0.
 
Ex: I have a function A() = which in turn=20 calls functions b() and c() , if i want commit something in b or c. i = have to=20 use
 
start transaction read = write;
-- set of sql statements and = then say=20 commit.
commit;
 
but this is not working it is = showing the=20 the following error near start transaction read write
"=20 ERROR:  SPI_execute_plan failed executing query "start transaction = read=20 write": SPI_ERROR_TRANSACTION ";
 
or
 
 if i use only commit = with out the=20 start transaction command it throwing the runtime = error
as
 
 
" ERROR:  = SPI_execute_plan failed=20 executing query "commit": SPI_ERROR_TRANSACTION ";
  
 
Can any one send me an example = of how to=20 use the start transaction or how to commit an nested = transaction.
 
Thanks in = advance.
 
 
Thanks & = Regards,
Sri
 
 
------=_NextPart_000_000F_01C5D319.B6F6FC10--