X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7CF46D1B16F for ; Wed, 26 May 2004 12:19:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 13752-05 for ; Wed, 26 May 2004 12:19:23 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 1108ED1B278 for ; Wed, 26 May 2004 12:19:22 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i4QDgU9U014651; Wed, 26 May 2004 09:42:30 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i4QFIeN17158; Wed, 26 May 2004 11:18:41 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id LP85G1L2; Wed, 26 May 2004 11:18:39 -0400 Subject: Re: [webmaster] Problem with 'report a bug form' From: Robert Treat To: David Brownlee Cc: pgsql-www@postgresql.org In-Reply-To: <03AF4E498C591348A42FC93DEA9661B889FEA1@mail.vale-housing.co.uk> References: <03AF4E498C591348A42FC93DEA9661B889FEA1@mail.vale-housing.co.uk> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 26 May 2004 11:18:40 -0400 Message-Id: <1085584720.9116.1972.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/119 X-Sequence-Number: 4498 David, what made you think that the submission didn't work? I show your report in the archives at http://archives.postgresql.org/pgsql-bugs/2004-05/msg00130.php Robert Treat On Tue, 2004-05-25 at 03:29, Dave Page wrote: > Can someone take a look at this problem reported by David please (the > bug form that is, not the JDBC issue)? I'm pretty swamped right now :-( > > Regards, Dave. > > > -----Original Message----- > > From: David Brownlee [mailto:abs@absd.org] > > Sent: 22 May 2004 18:15 > > To: webmaster@postgresql.org > > Subject: [webmaster] Problem with 'report a bug form' > > > > Submit does not appear to work: > > > > Contents were: > > > > > > In AbstractJdbc2ResultSet:parseQuery can end up leaving a ; > > on the end of a tablename, which when later used in > > isUpdateable() will choke. > > The following 'fixes' it: > > > > --- org/postgresql/jdbc2/AbstractJdbc2ResultSet.java.orig > > 2004-05-21 > > 12:54 > > :29.000000000 +0100 > > +++ org/postgresql/jdbc2/AbstractJdbc2ResultSet.java > > @@ -1448,7 +1450,7 @@ public abstract class AbstractJdbc2Resul > > { > > if > > (name.toLowerCase().equals("from")) > > { > > - tableName = st.nextToken(); > > + tableName = > > st.nextToken().replaceAll("; > > ", ""); > > tableFound = true; > > } > > > > This was found while writing a small java tool to copy the > > contents of one database to another, which can be provided to > > demonstrate the problem on request. Would have attached it > > here if there had been an option :) > > > > -- > > David Brownlee -- abs@absd.org > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to > > majordomo@postgresql.org > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL