Re: query manipulation

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