Re: id field error
От | Surojit Niyogi |
---|---|
Тема | Re: id field error |
Дата | |
Msg-id | 3CC9CF37.1090602@bungeecode.com обсуждение исходный текст |
Ответ на | id field error (angelo.rigo@globo.com) |
Список | pgsql-php |
You can either use the datatype "SERIAL" or if you have a way of generating unique IDs based off of microtimes, you can get away with putting a unique value into field "id" as it is right now. Roj Niyogi pgHoster PostgreSQL web hosting angelo.rigo@globo.com wrote: >Hi ! >I´m doing my first publishing system for a last aquired boooks for a library. > >the problem begin in the id field, wich i choose to be primary key and unique. >i could just insert data one time the others give me this error: > > Cannot insert a duplicate key into unique index biblioteca_pkey > >i use this piece of code below to insert the data: > >$query = "INSERT INTO biblioteca (id, autor, titulo, editora) values ('$id', >'$autor', '$titulo', '$editora')"; >$result = pg_exec($db, $query); > >may i can alter the id collumn and the query to insert the data anybody >knows what exactly to do ? > >Thank´s > >Ângelo > > > > >________________________________________ >A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > > > >
В списке pgsql-php по дате отправления: