Re: going crazy with serial type

Cindy wrote:

>OK, next question. I'm trying to use nextval/currval and I'm getting
>this:
>
>search_info=# select currval('state_vectors_id_seq');
>ERROR: state_vectors_id_seq.currval is not yet defined in this session
>search_info=# select id from state_vectors;
> id
>----
> 1
>(1 row)
>
>
>shouldn't the first select have returned 1? The state_vectors_id_seq
>
Nope. currval() is per session, so if you haven't called nextval()
during the current connection, you'll see exactly what you saw.

test=# create sequence testseq;
CREATE
test=# select currval('testseq');
ERROR: testseq.currval is not yet defined in this session
test=# select nextval('testseq');
nextval
---------
1
(1 row)

test=# select currval('testseq');
currval
---------
1
(1 row)

test=# \q

$ psql test

Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=# select currval('testseq');
ERROR: testseq.currval is not yet defined in this session
test=#

-Fran