sequence primary key
От
Virginie Garcia
Тема
sequence primary key
Дата
Msg-id
01071717435300.01122@BIOINFO1.pmtg.u-bordeaux2.fr
Ответ на
Confused about rights (Perry The Cynic)
Список
Дерево обсуждения
Confused about rights Perry The Cynic <perry@cynic.org>
sequence primary key Virginie Garcia <Virginie.Garcia@pmtg.u-bordeaux2.fr>
Re: sequence primary key Jason Earl <jdearl@yahoo.com>
Re: sequence primary key Tom Lane <tgl@sss.pgh.pa.us>
RE: sequence primary key "Robby Slaughter" <webmaster@robbyslaughter.com>
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 по дате отправления
