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$1@sea.gmane.org (view raw or flat)
Thread:
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
> 
>                http://www.postgresql.org/about/donate
> 

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

Randall


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-2014 The PostgreSQL Global Development Group