Using constraint

From: "TURPIN Olivier FTM/DSI/EXT" <olivier(dot)turpin(at)francetelecom(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Using constraint
Date: 2001-09-28 11:47:26
Message-ID: 3BB4634E.20660295@francetelecom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I have created two tables on v713:

create table table1
(
Name varchar(10)
);

create table2
(
Name varchar(10),
table1OID OID CONSTRAINT verif REFERENCES table1 ( OID )
);

I get an error message while creating table2, indicating that no UNIQUE
criteria exists on table1.
Does anyone can explain this to me ?

Thanks

Olivier

Browse pgsql-novice by date

  From Date Subject
Next Message Aarni Ruuhimäki / Megative Tmi 2001-09-28 15:41:25 Closing 5432 to the outside
Previous Message Yeo Eng Hee 2001-09-28 10:49:53 Problems installing Pg module on Tru64 Unix