Re: [BUGS] 7.4: serial not working ?

#1

vertigo wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] 7.4: serial not working ?

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] 7.4: serial not working ? - 07-03-2004 , 06:08 PM