Re: going crazy with serial type

From: mordicus <mordicus(at)free(dot)fr>
To: Cindy <ctmoore(at)uci(dot)edu>, pgsql-general(at)postgresql(dot)org
Subject: Re: going crazy with serial type
Date: 2002-01-31 21:56:12
Message-ID: 200201312156.UAA03232@mordicus.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-01-31 22:01:22 Re: going crazy with serial type
Previous Message Ellen Cyran 2002-01-31 21:48:55 Re: Function to Pivot data