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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
