SERIAL type not autoincremented
От | teknet@poczta.onet.pl |
---|---|
Тема | SERIAL type not autoincremented |
Дата | |
Msg-id | 20040702172227Z4873738-14310+28550@kps5.test.onet.pl обсуждение исходный текст |
Ответы |
Re: SERIAL type not autoincremented
Re: SERIAL type not autoincremented Re: SERIAL type not autoincremented standard IDENTITY support (Was: Re: SERIAL type not autoincremented) |
Список | pgsql-admin |
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" Why ? Do i understeand correctly that SERIAL == AUTO_INCREMENT ? As far as i remember i used such type in the past and had no problem. What do i miss ? Thanx Michal
В списке pgsql-admin по дате отправления: