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
|
- [BUGS] function currval(character varying) does not ... Jean-Pierre Pelletier