Re: [HACKERS] Beta for 4:30AST ... ?

Don Baccus <dhogaza@pacifier.com>

From: Don Baccus <dhogaza@pacifier.com>
To: The Hermit Hacker <scrappy@hub.org>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: webmaster@postgresql.org, pgsql-hackers@postgresql.org
Date: 2000-02-22T00:34:48Z
Lists: pgsql-hackers
At 07:57 PM 2/21/00 -0400, The Hermit Hacker wrote:

>   * -Add referential integrity(Jan)[primary]

This is only PARTIALLY complete:

MATCH FULL and MATCH <unspecified> foreign keys and their related
referential actions are complete.  MATCH PARTIAL isn't in - I'll be
doing that for 7.1.

It doesn't check that the columns referenced in a foreign key
form a primary key or are contrained by UNIQUE in the referenced
table.  This will be checked in 7.1, not sure who will do it (who
ever gets to it first, probably).

Those are the two major user-visible loose ends with this feature.



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