Received: from flip.wildbrain.com ([206.54.55.32]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6H2pua47481 for ; Mon, 16 Jul 2001 22:51:56 -0400 (EDT) (envelope-from dado@wildbrain.com) Received: from wildbrain.com (daedelus.wildbrain.com [192.168.1.38]) by flip.wildbrain.com (8.9.3/8.9.3) with ESMTP id SAA01230 for ; Mon, 16 Jul 2001 18:47:52 -0700 Message-ID: <3B53A705.4060807@wildbrain.com> Date: Mon, 16 Jul 2001 19:46:29 -0700 From: Dado Feigenblatt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2) Gecko/20010628 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql Subject: ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/208 X-Sequence-Number: 4004 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@wildbrain.com San Francisco, CA.