sequence primary key

From: Virginie Garcia <Virginie(dot)Garcia(at)pmtg(dot)u-bordeaux2(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: sequence primary key
Date: 2001-07-17 15:43:53
Message-ID: 01071717435300.01122@BIOINFO1.pmtg.u-bordeaux2.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Robby Slaughter 2001-07-17 16:14:19 RE: COUNT doesn't shows items with 0 occurrance
Previous Message Jiri D. Hoogeveen 2001-07-17 15:21:05 execute sql in a function?