serial - Mailing list pgsql-general

From Gustavo Rosso
Subject serial
Date
Msg-id 4937EC45.4010307@sadaic.org.ar
Whole thread Raw
Responses Re: serial
Re: serial
Re: serial
Re: serial
List pgsql-general
I created this table:

create table se (n  serial);

 Column |  Type      |                   Modifiers
---------+---------+------------------------------------------------
 n           | integer    | not null default nextval('se_n_seq'::regclass)

I inserted two record, later select, but column n (serial) no
auto-incremented
banco=# select * from se;
 n
---
 0
 0
(2 rows)

Why?
Thanks
Gustavo

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: column name order matters in insert into foo from bar
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: column name order matters in insert into foo from bar