Horton

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

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Don Baccus <dhogaza@pacifier.com>
Cc: The Hermit Hacker <scrappy@hub.org>, Tom Lane <tgl@sss.pgh.pa.us>, webmaster@postgreSQL.org, pgsql-hackers@postgreSQL.org
Date: 2000-02-22T00:57:36Z
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.

Added to TODO.

> 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).

Added.  

* Foreign key does not check that columns referenced form a primary key 
  or constrained by UNIQUE

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026