Hi,
 
   pstmt = connection.prepareStatement("select currval(?)"); throws "function currval(character varying) does not exist"
 
   Using pgAdmin, I could see that currval() now takes a regclass parameter, so
   I got it to work using
 
   pstmt = connection.prepareStatement("select currval(cast(cast(? as text) as regclass))");
   Is currval(text) gone for good or is this an oversight?
   If it's gone for good, is cast(cast(? as text) as regclass) the recommended way of handling this?
 
   I am using PostgreSQL 8.1 beta3 under Windows XP Service Pack 2 with JDBC3 8.1 Build 402.
   It worked fine with PostgreSQL 8.1 beta2 and with 8.0.*
 
Thanks,
Jean-Pierre Pelletier
e-djuster

Reply via email to