Received: from web14914.mail.yahoo.com (web14914.mail.yahoo.com [216.136.225.241]) by postgresql.org (Postfix) with SMTP id 5BF06475469 for ; Tue, 26 Feb 2002 02:43:41 -0500 (EST) Message-ID: <20020226074341.15101.qmail@web14914.mail.yahoo.com> Received: from [202.161.138.9] by web14914.mail.yahoo.com via HTTP; Mon, 25 Feb 2002 23:43:41 PST Date: Mon, 25 Feb 2002 23:43:41 -0800 (PST) From: "Kancha ." Subject: Re: [SQL] transaction abortion To: Christopher Kings-Lynne , pgsql-sql@postgresql.org Cc: pgsql-general@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200202/1251 X-Sequence-Number: 21243 here is the exact query : begin; update cst_package set status='f' where cid='28' and status='t'; insert into cst_package (startdate, enddate, status, pkgid, cid) values ('2002-02-14', '2003-02-14', 't', '112', '28'); select acb_transaction.amount as amount, acb_transaction.iscredit as iscredit, acb_ledger.lid as lid from acb_transaction,acb_ledger where acb_ledger.lid = acb_transaction.lid and acb_ledger.cid =(select cid from cst_customer where loginname = 'myname') and acb_ledger='t'; It is after the last one ( the select) query the transaction is aborted. The query is ok. The select query is executed successfully if it is not within a transaction. --- Christopher Kings-Lynne wrote: > Hi Kancha, > > Chances are you have a syntax error in the select > statement. Can you please > port the entire set of queries you are trying to run > and we'll look at them. > > Chris > > > -----Original Message----- > > From: pgsql-sql-owner@postgresql.org > > [mailto:pgsql-sql-owner@postgresql.org]On Behalf > Of Kancha . > > Sent: Tuesday, 26 February 2002 2:35 PM > > To: pgsql-sql@postgresql.org > > Cc: pgsql-general@postgresql.org > > Subject: [SQL] transaction abortion > > > > > > I'm in a situtation where transaction is aborted. > I'm > > a newbie so please help. > > > > I start transaction with begin then do some > queries > > like update and insert. So far so good, but when i > run > > select query within the transaction the whole > > transaction is aborted. > > > > what should i do ?? > > > > > > > __________________________________________________ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com