Re: going crazy with serial type

Le Jeudi 31 Janvier 2002 18:40, Cindy a écrit :

> create table mytable (mytable_id serial, a int, b int);
>
> and
>
> insert into mytable ('', 1, 2); is accepted but then following
> insert into mytable ('', 5, 6); etc, is rejected due to "duplicate key"
>

insert into mytable (a,b) values (1,2);
insert into mytable (a,b) values (5,6);

>
> Thanks,
> --Cindy