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 ?
Thanx Michal
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
