creating a table with a serial column sets currval - Mailing list pgsql-bugs

From Kris Jurka
Subject creating a table with a serial column sets currval
Date
Msg-id Pine.BSO.4.64.0710181606530.12647@leary.csoft.net
Whole thread Raw
Responses Re: creating a table with a serial column sets currval
List pgsql-bugs
jurka=# create table t (c serial);
NOTICE:  CREATE TABLE will create implicit sequence "t_c_seq" for serial
column "t.c"
CREATE TABLE
jurka=# select currval('t_c_seq');
  currval
---------
        1
(1 row)

I would expect it to say that currval wasn't set like so:

jurka=# create sequence myseq;
CREATE SEQUENCE
jurka=# select currval('myseq');
ERROR:  currval of sequence "myseq" is not yet defined in this session

Kris Jurka

pgsql-bugs by date:

Previous
From: Julius Stroffek
Date:
Subject: Re: 'on insert do instead' rule with a where clause responds 'INSERT 0 0'
Next
From: Kris Jurka
Date:
Subject: Re: creating a table with a serial column sets currval