foreign keys? - Mailing list pgsql-hackers

From Don Baccus
Subject foreign keys?
Date
Msg-id 3.0.1.32.20000122180428.01049040@mail.pacifier.com
Whole thread Raw
Responses Re: [HACKERS] foreign keys?
List pgsql-hackers
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...



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Happy column dropping
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] Well...