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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org