[EMAIL PROTECTED] wrote: > > Hello > i have: > create table student( > id SERIAL NOT NULL, > name VARCHAR(35) NOT NULL, > primary key (id) > ); > > and when i try to insert like this: > insert into student (name) values('me'); > i receive error: > ERROR: duplicate key violates unique constraint "student_pkey"
You must be leaving something out of the story... $ psql Password: Welcome to psql 7.4.2, the PostgreSQL interactive terminal. ... jseymour=# create table student( jseymour(# id SERIAL NOT NULL, jseymour(# name VARCHAR(35) NOT NULL, jseymour(# primary key (id) jseymour(# ); NOTICE: CREATE TABLE will create implicit sequence "student_id_seq" for "serial" column "student.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "student_pkey" for table "student" CREATE TABLE jseymour=# insert into student (name) values('me'); INSERT 8776502 1 jseymour=# insert into student (name) values('me'); INSERT 8776503 1 jseymour=# insert into student (name) values('me'); INSERT 8776504 1 jseymour=# select * from student; id | name ----+------ 1 | me 2 | me 3 | me (3 rows) Seems to work here. Jim ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match