Kris,
Sorry for wasting your time. We ran your sample and it worked.
Upon further investigation, our tomcat web servers have a copy of a postgres
jar file that it must use instead of the one with our webapp. Who knows how
old it is. We upgraded that one and the problem went away.
Thanks for your help,
Woody
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Kris Jurka
> Sent: Wednesday, March 19, 2008 11:35 PM
> To: Woody Woodring
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] JDBC rewriting a bad query?
>
>
>
> On Wed, 19 Mar 2008, Woody Woodring wrote:
>
> > We were able to reproduce the issue with
> postgresql-8.3-603.jdbc3.jar.
> > Please let me know if I can be of any assistance in finding
> the issue.
> >
>
> If you can send a self-contained test case, I'd be happy to
> look at it. I tried the attached test case and I get the expected:
>
> Exception in thread "main" org.postgresql.util.PSQLException: ERROR:
> syntax error at or near ")"
> Position: 356
>
>
> Kris Jurka
>