no unique constraint matching given keys for referenced table
| От | Lonni J Friedman |
|---|---|
| Тема | no unique constraint matching given keys for referenced table |
| Дата | |
| Msg-id | AANLkTi=GhUmFRKoS7BFuobqg9k9DncTjXK4gdK2eiUxT@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: no unique constraint matching given keys for referenced table
|
| Список | pgsql-novice |
I'm trying to create some references while creating a few new tables
and its going poorly. For each attempt, I'm getting the error:
ERROR: there is no unique constraint matching given keys for
referenced table "foo"
Here's what table foo looks like:
Column | Type |
Modifiers
----------------+-----------------------------+--------------------------------------------------------
id | integer | not null default
nextval('foo_id_seq'::regclass)
date_created | timestamp without time zone | not null
Indexes:
"foo_pkey" PRIMARY KEY, btree (id)
Here's how I'm attempting to create the new table (bar):
# create table bar (id serial PRIMARY KEY, suiteid integer REFERENCES foo(id)) ;
NOTICE: CREATE TABLE will create implicit sequence "bar_id_seq" for
serial column "bar.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bar_pkey" for table "bar"
ERROR: there is no unique constraint matching given keys for
referenced table "foo"
My understanding is that this should work as long as foo.id is unique
(which it is). I thought that maybe the lack of an explicit primary
key on foo might have been the problem, but I can't create one because
it already exists. Clearly I'm missing something else fundamental?
thanks
В списке pgsql-novice по дате отправления: