Skip site navigation (1) Skip section navigation (2)

Re: query manipulation

From: Randall Smith <randall(at)tnr(dot)cc>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: query manipulation
Date: 2007-03-19 20:35:02
Message-ID: etms5n$7or$ (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Randall Smith wrote:
> I'm trying to find a way to manipulate some poorly written queries in 
> which I don't have access to the application source.  I can't do it at 
> the Postgresql server, so I'm thinking of attacking it at the jdbc driver.
> I was thinking of a wrapper that would look at and alter the SQL before 
> it went to the server.  Anyone know of something like this? 
> Specifically, I'm trying to drop "FOR UPDATE column name" off of some 
> queries.  They were written for Oracle, but Postgresql uses "FOR UPDATE 
> table name".  I'm not a Java programmer, but I won't let that stop me if 
> it is required.
> Randall
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at

Sorry.  That's "FOR UPDATE OF column_name", not "FOR UPDATE column_name".


In response to

pgsql-jdbc by date

Next:From: Dave CramerDate: 2007-03-19 20:37:31
Subject: Re: query manipulation
Previous:From: Randall SmithDate: 2007-03-19 20:19:51
Subject: query manipulation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group