Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using constraint

Using constraint

From
"TURPIN Olivier FTM/DSI/EXT"
Date:
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