ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found

From: Dado Feigenblatt <dado(at)wildbrain(dot)com>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found
Date: 2001-07-17 02:46:29
Message-ID: 3B53A705.4060807@wildbrain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I'm trying to create some tables with foreign keys.
When I try to create a foreign key ...

foreign key(seq_code) references sequences(seq_code) on update
CASCADE on delete CASCADE,

I get this message:

ERROR: UNIQUE constraint matching given keys for referenced table
"sequences" not found

The problem is that the referenced field and table exist.
Any hint?

Using psql and PostgreSQL 7.1.1 on RedHat 7.1
Thanks.

--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 553-8000 x???
dado(at)wildbrain(dot)com San Francisco, CA.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-07-17 08:37:07 Re: ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found
Previous Message Peter Eisentraut 2001-07-16 20:52:52 Re: interpreting attributes in pg_class