function currval(character varying) does not exist, PostgreSQL 8.1 beta3

Поиск
Список
Период
Сортировка
От Jean-Pierre Pelletier
Тема function currval(character varying) does not exist, PostgreSQL 8.1 beta3
Дата
Msg-id BAYC1-PASMTP05E81F9F75ED0B8719529095730@CEZ.ICE
обсуждение исходный текст
Ответы Re: function currval(character varying) does not exist, PostgreSQL 8.1 beta3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi,

   pstmt =3D connection.prepareStatement("select currval(?)"); throws "func=
tion 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 =3D connection.prepareStatement("select currval(cast(cast(? as tex=
t) 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 recommen=
ded way of handling this?

   I am using PostgreSQL 8.1 beta3 under Windows XP Service Pack 2 with JDB=
C3 8.1 Build 402.
   It worked fine with PostgreSQL 8.1 beta2 and with 8.0.*

Thanks,
Jean-Pierre Pelletier
e-djuster=

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: BUG #1947: Enhancement Request - CONCAT() function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: function currval(character varying) does not exist, PostgreSQL 8.1 beta3