Using constraint - Mailing list pgsql-novice

From TURPIN Olivier FTM/DSI/EXT
Subject Using constraint
Date
Msg-id 3BB4634E.20660295@francetelecom.com
Whole thread Raw
List 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


pgsql-novice by date:

Previous
From: James Hall
Date:
Subject: Re: access to postgres?
Next
From: "richard leotard"
Date:
Subject: functionss