Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 552B8475EBA
	for <pgsql-docs@postgresql.org>; Tue,  3 Sep 2002 13:52:20 -0400 (EDT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by postgresql.org (Postfix) with ESMTP id 90DA0475E84
	for <pgsql-docs@postgresql.org>; Tue,  3 Sep 2002 13:52:18 -0400 (EDT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.10.1) id g83HqCO00594;
	Tue, 3 Sep 2002 13:52:12 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200209031752.g83HqCO00594@candle.pha.pa.us>
Subject: Re: PostgreSQL 7.2 Documentation
In-Reply-To: <71BFB6708920D211967300805F85071C072A73@UBK_SRV1>
To: mathias@ubik.ch
Date: Tue, 3 Sep 2002 13:52:12 -0400 (EDT)
Cc: pgsql-docs@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/14
X-Sequence-Number: 1466


Yes, this is fixed in 7.3, due out in a few months.

---------------------------------------------------------------------------

Mathias Zajaczkowski wrote:
> 
> 3.3. Foreign Keys
> 
> [..]
> CREATE TABLE cities (
> 	name		varchar(80) primary key,
> 	location	point
> );
> 
> CREATE TABLE weather (
> 	city		varchar(80) references weather,
> 	temp_lo		int,
> 	temp_hi		int,
> 	prcp		real,
> 	date		date
> );
> 
> Table weather refernces table cities and not itself.
> Best regards
> 
> Mathias Zajaczkowski,
> UBIK S.A.
> Av. Cortot 7d,
> 1260, Nyon, Switzerland
> Tel : +41 22 362 04 60
> Fax: +41 22 362 04 61
> mailto:mathias@ubik.ch
> http://www.ubik.ch
> 
> ?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073