Received: from web14901.mail.yahoo.com (web14901.mail.yahoo.com [216.136.225.53]) by postgresql.org (Postfix) with SMTP id E29B147546E for ; Tue, 26 Feb 2002 01:35:15 -0500 (EST) Message-ID: <20020226063514.41422.qmail@web14901.mail.yahoo.com> Received: from [202.161.138.9] by web14901.mail.yahoo.com via HTTP; Mon, 25 Feb 2002 22:35:14 PST Date: Mon, 25 Feb 2002 22:35:14 -0800 (PST) From: "Kancha ." Subject: transaction abortion To: pgsql-sql@postgresql.org Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200202/1250 X-Sequence-Number: 21242 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