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  ("Robby Slaughter" <webmaster@robbyslaughter.com>)
Re: sequence primary key  (Jason Earl <jdearl@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Giorgio A."
Дата:
Сообщение: COUNT doesn't shows items with 0 occurrance
Следующее
От: "Robby Slaughter"
Дата:
Сообщение: RE: COUNT doesn't shows items with 0 occurrance