Erik Price schrieb:
> I have read the manual about sequences and I thought I understood both
> their purpose and how to use them. When I perform inserts, the sequence
> is updated appropriately. However, I can't seem to directly access the
> sequence myself. I always seem to get this message:
>
> be_db=# select currval('news_news_id_seq');
> ERROR: news_news_id_seq.currval is not yet defined in this session
>
> Can someone explain what is going on?
I think the other explenations where pretty good. However there *is* a way
to retrieve the "current value" of sequence regardless whether nextval was
called or not:
SELECT last_value FROM news_news_id_seq;
Regards
Thomas