Re: going crazy with serial type - Mailing list pgsql-general

From mordicus
Subject Re: going crazy with serial type
Date
Msg-id 200201312156.UAA03232@mordicus.localdomain
Whole thread Raw
In response to going crazy with serial type  (Cindy <ctmoore@uci.edu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: process exited with status 11 after XLogFlush: request is not satisfied
Next
From: Neil Conway
Date:
Subject: Re: index does not improve performance