How are you accessing currval(). Can you post an example?
currval() is implemented in the backend, so there should be no difference
between how its returned and how any other value is returned, so it might be
how you are calling it thats not working.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council
> -----Original Message-----
> From: tony [mailto:tony@uickarate.com]
> Sent: Wednesday, November 29, 2000 1:16 AM
> To: pgsql-interfaces
> Subject: [INTERFACES] currval() problem
>
>
> Hello
>
> I have a problem with currval() through JDBC.
> My nextval() updates the counter of sequences, but
> currval() returns no value even after I call nextval().
> Both work fine when I try them through psql.
> Have you encountered this problem before??
>
>
> Tony
>