Foreign Key Question

From: Tuan Luu <tuanluu(at)gmx(dot)ch>
To: pgsql-novice(at)postgresql(dot)org
Subject: Foreign Key Question
Date: 2004-02-09 08:04:19
Message-ID: 40273F03.4050403@gmx.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Example:

Table 1:
Inventory, Productnr, Productserial
(PK Inventory, Prouctnr)

Table 2:
Pruductnr, Produktdesc, Productversion
(PK Productnr; FK Productnr)

This Construct gives me an error during the creation in Postgresql
(saying there is no unique constraint matching given keys for referenced
table xxxx). The Primary Key in table 1 consists of two columns. In the
second table there is a foreign key refencing to the first table.
A unique constraint doesn't make sense on table one. Am I missing
something here?
Thanks for any answer
Tuan

Browse pgsql-novice by date

  From Date Subject
Next Message Rajan Bhide 2004-02-09 12:06:39 Performing COPY Command
Previous Message Josh Berkus 2004-02-09 05:36:45 Re: Storing Perl objects