Referential integrity: broken rule? - Mailing list pgsql-sql

From Franz J Fortuny
Subject Referential integrity: broken rule?
Date
Msg-id 013401c033b8$087d91e0$3167a8c0@chapur
Whole thread Raw
Responses Re: Referential integrity: broken rule?
List pgsql-sql
This table:

create table things
( idthing integer not null, isthis boolean not null primary key(idthing,isthis)
....

)

would be referenced by this one:

create table forthings
( fromthing integer not null references things(idthing),

....

)

The above SHOULD NOT be accepted, since table "things" did not declare
idthing as UNIQUE. However, it IS accepted under PostgreSQL (7.0.2).

Am I wrong?

Best regards,

F J Fortuny




pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: SQL to retrieve foreign keys
Next
From: Stephan Szabo
Date:
Subject: Re: Referential integrity: broken rule?