serial

From: Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: serial
Date: 2008-12-04 14:42:13
Message-ID: 4937EC45.4010307@sadaic.org.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: serial at 2008-12-04 13:41:57 from Pavel Stehule
  • Re: serial at 2008-12-04 13:43:28 from Grzegorz Jaśkiewicz
  • Re: serial at 2008-12-04 13:45:50 from Serge Fonville
  • Re: serial at 2008-12-04 14:06:33 from Scott Marlowe

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Williamson 2008-12-04 14:47:46 Re: serial
Previous Message Scott Marlowe 2008-12-04 14:16:38 Re: pg_stat_activity