Re: serial - Mailing list pgsql-general

From Serge Fonville
Subject Re: serial
Date
Msg-id 680cbe0e0812040545p1d07e6f0r49a9a0c5ef7eb50f@mail.gmail.com
Whole thread Raw
In response to serial  (Gustavo Rosso <grosso@sadaic.org.ar>)
List pgsql-general
On Thu, Dec 4, 2008 at 3:42 PM, Gustavo Rosso <grosso@sadaic.org.ar> wrote:
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

You inserted values in a table with only a serial column?

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: serial
Next
From: paulo matadr
Date:
Subject: pg_stat_activity