Re: [HACKERS] foreign keys?

>I've built current sources on my brand new linux box,
>thought I'd try foreign key constraints since the datamodel for
>the ArsDigita Community System contains hundreds of them.
>Figured this might provide a bit of a stress test for the
>implementation.
>
>So...what's wrong with the following?
>
>donb=> create table foo(i integer);
>CREATE
>donb=> create table bar(i integer references foo);
>ERROR: FOREIGN KEY match type UNSPECIFIED not implemented yet
>donb=>
>
>This is how I'm used to doing it in Oracle. I've tried a few
>permutations, what am I missing? My copy of Date is still in
>Boston...

As of the last snapshot I downloaded, only MATCH FULL was
implemented fully and I think postgres will only be happy
if you specify the column list or table foo has a primary key.

create table bar(i integer references foo(i) match full);

That seems to work, although by the way I read the spec, I'm
not sure that it should since there is no unique constraint
specified on foo(i).