sequence primary key
От | Virginie Garcia |
---|---|
Тема | sequence primary key |
Дата | |
Msg-id | 01071717435300.01122@BIOINFO1.pmtg.u-bordeaux2.fr обсуждение исходный текст |
Ответ на | Confused about rights (Perry The Cynic <perry@cynic.org>) |
Ответы |
RE: sequence primary key
Re: sequence primary key |
Список | pgsql-novice |
Hi all, my question is about sequences and primary key of a table. More details : I create a sequence and a table with these lines : CREATE SEQUENCE "my_id" INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1; CREATE TABLE "toto" ( "toto_id" integer PRIMARY KEY DEFAULT nextval('"my_id"'), "db" text); in a a sql file. In fact, when I fill database I would like "toto_id" field to be filled directly by sgdb by using sequence "my_id" but not by me. This way doesn't work. It's perhaps a big mistake !!! How is-it possible, so ? Thanks a lot. Virginie.
В списке pgsql-novice по дате отправления: