Amit> Andrew also mentioned a workaround in his reply to use setString Amit> such that JDBC doesn't pass 'MONTH' as of type 'text' and instead Amit> as of unknown type. I could't find the documentation of Postgres Amit> JDBC's setString to see how one can do that, but maybe you can Amit> try it out.
Disclaimer: I don't do java stuff myself, all I know about this is from reading the code.
First, there's a connection parameter stringtype=unspecified that affects all setString calls on the connection. Second, there may be a way to use setObject instead; setObject(1, str, Types.DISTINCT) looks like it might work (or maybe Types.OTHER) - unless I'm completely misreading the pgjdbc code, that should end up sending the right thing to the server.
