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