Then I don't need primary key ? If I choose my primary key to be an integer then I have to keep track of numbers and automatically insert number incremented by one ? I worked long ago with Access and it automatically inserts number incremented by one as id. I guess than this is part of Access program and not the underlaying database ?
Then I don't need primary key ?
(Read up on what primary keys really do.)
If I choose my primary key to be an integer then I have to keep track of numbers and automatically insert number incremented by one ?
No, Postgres supports automatically assigned IDs as well, but you have to specify them. Look into the serial datatype, and default column values.
postmodern-devel@common-lisp.net
-
Haris -
Marijn Haverbeke