Search Postgresql Archives

Re: serial

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Dec 4, 2008 at 3:42 PM, Gustavo Rosso <grosso@xxxxxxxxxxxxx> 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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux