Re: [HACKERS] JPA + enum == Exception

On 5 July 2013 19:27, Dave Cramer <pg@fastcrypt.com> wrote:

I would think setObject should respect stringtype=unspecified. So I would be willing to accept this as a solution

OK, here's a pull request with a unit test to cover expected behaviour with different combinations of setObject and setString, for inserts and queries.

https://github.com/pgjdbc/pgjdbc/pull/68

Interestingly, when I first tried this I tried using point as the type to test rather than an enum (so that I didn't have to create the enum type in the test), but it would fail when trying to select a row out in a query like "select * from thetable where p = ?" saying "operator does not exist: point = unknown". I presume that this due to multiple = operators for the point type at the db level, so the backend can't decide which type to create. I guess there's not much that we can do about that - if things are ambiguous then you need to be more specific, and of course we have a PGpoint java object anyway.

Cheers

Tom