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