Re: Currval function won't work

On Fri, Oct 07, 2005 at 04:54:13PM -0700, Bluebottle wrote:
> select currval('library.items_itemid_seq') as NextItemID;
> ERROR:  currval of sequence "items_itemid_seq" is not yet defined in
> this session

currval() returns the value most recently obtained from nextval()
in the current session.  If you haven't called nextval() yet then
you get the error above.  Example:

test=> CREATE SEQUENCE foo_seq;
CREATE SEQUENCE
test=> SELECT currval('foo_seq');
ERROR:  currval of sequence "foo_seq" is not yet defined in this session
test=> SELECT nextval('foo_seq');
 nextval
---------
       1
(1 row)

test=> SELECT currval('foo_seq');
 currval
---------
       1
(1 row)

> Note that the nextval function works as expected
>
> select nextval('library.items_itemid_seq') as NextItemID;
> 2313

You should be able to call currval() after calling nextval().  If
not then please tell us a little more about your environment, such
as whether you're using a connection pool.

--
Michael Fuhr