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
CREATE TABLE "toto" (
"toto_id" integer PRIMARY KEY DEFAULT nextval('"my_id"'),
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.
In response to
pgsql-novice by date
|Next:||From: Robby Slaughter||Date: 2001-07-17 16:14:19|
|Subject: RE: COUNT doesn't shows items with 0 occurrance|
|Previous:||From: Jiri D. Hoogeveen||Date: 2001-07-17 15:21:05|
|Subject: execute sql in a function?|