X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 844005E46C8 for ; Fri, 20 Aug 2004 05:09:26 -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 02370-04 for ; Fri, 20 Aug 2004 08:09:18 +0000 (GMT) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by svr1.postgresql.org (Postfix) with ESMTP id 8DFB75E46C5 for ; Fri, 20 Aug 2004 05:09:18 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-34.mail.demon.net with esmtp (Exim 3.35 #1) id 1By4Sd-000OuJ-0Y; Fri, 20 Aug 2004 08:09:19 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id D35B1167D8; Fri, 20 Aug 2004 09:09:17 +0100 (BST) Message-ID: <4125B1AD.9050403@archonet.com> Date: Fri, 20 Aug 2004 09:09:17 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 0.7 (X11/20040615) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kevin Matthews Cc: pgsql-general@postgresql.org Subject: Re: need help References: <20040817203657.48827.qmail@web40405.mail.yahoo.com> In-Reply-To: <20040817203657.48827.qmail@web40405.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/922 X-Sequence-Number: 64477 Kevin Matthews wrote: > subscribe end > > i am getting this error > > org.apache.jasper.JasperException: ERROR: current transaction is > aborted, queries ignored until end of transaction block It appears an error has occurred in your current transaction, which has caused it to abort. Until you issue a ROLLBACK, any further queries will be ignored. You probably need to look in PostgreSQL's logs to see what caused the error, or check the error codes from SQL commands issued from jasper's code. -- Richard Huxton Archonet Ltd