Обсуждение: Re: 7.4: serial not working ?

vertigo wrote:

> Hello
> i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL
> exists but does not working. Example:
> My table:
> create table1(
> id SERIAL,
> name VARCHAR(100)
> );
>
> insert into table1 (name) values('name1');
> ERROR:  duplicate key violates unique constraint "table1_pkey"
>
> Why ? I want to have autoincrementation. I do not know (when i insert
> record) what id values should it have.
> How can i solve this problem ?

when you define the serial it start from 1. If you filled that table
specifing also the serial value then the serial was not incremented,
in order to solve your problem setting the serial value equal to
max(id)+1 in that table.



Regards
Gaetano Mendola