Hello all,
I am trying to convert an older PG database where we stored GUID keys by
explicitly converting them to byte arrays before storing them in bytea
columns in the DB to a database where we use the new UUID type sup****ted
by PG 8.3.
I am having trouble setting such a value through a JDBC
PreparedStatement because any stmt.setXXX(i,...) I have tried results in
an error about a mismatch between type UUID and XXX.
How can I get my PreparedStatement to work correctly?
Kind regards,
Silvio Bierman
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
