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