Re: BUG #15334: Partition elimination not working as expected whenusing enum as partition key

>>>>> "Amit" == Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> writes:

 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.

--
Andrew (irc:RhodiumToad)