Home > mailing lists

Currval function won't work - Mailing list pgsql-novice

From	Bluebottle
Subject	Currval function won't work
Date	October 7, 2005 07:27:09
Msg-id	000001c5cb9a$6bd88040$0300a8c0@DavidsPC Whole thread Raw
Responses	Re: Currval function won't work (Michael Fuhr <mike@fuhr.org>) Re: Currval function won't work (<operationsengineer1@yahoo.com>)
List	pgsql-novice

select currval('library.items_itemid_seq') as NextItemID;

ERROR: currval of sequence "items_itemid_seq" is not yet defined in this session

Note that the nextval function works as expected

select nextval('library.items_itemid_seq') as NextItemID;

2313

Can somebody please tell me what simple mistake I am making?

David

From: Tom Lane
Date: 07 October 2005, 03:27:32
Subject: Re: Order by and index

From: Michael Fuhr
Date: 07 October 2005, 08:06:10
Subject: Re: Currval function won't work