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.
Enterprise Support Officer, Maidstone Borough Council
All views expressed within this email are not the views of Maidstone Borough
> -----Original Message-----
> From: tony [mailto:tony(at)uickarate(dot)com]
> Sent: Wednesday, November 29, 2000 1:16 AM
> To: pgsql-interfaces
> Subject: [INTERFACES] currval() problem
> 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??
pgsql-interfaces by date
|Next:||From: Tibor Laszlo||Date: 2000-11-29 11:01:04|
|Subject: Re: slow odbc access....|
|Previous:||From: Peter Mount||Date: 2000-11-29 09:35:08|