Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 7.2 Documentation

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: mathias(at)ubik(dot)ch
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: PostgreSQL 7.2 Documentation
Date: 2002-09-03 17:52:12
Message-ID: 200209031752.g83HqCO00594@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docs
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(at)ubik(dot)ch
> http://www.ubik.ch
> 
> ?

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

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 2002-09-03 18:53:05
Subject: Re: wrong information about unlimied size of text field?
Previous:From: Janning VygenDate: 2002-09-03 15:12:59
Subject: VERY SMALL DOC BUG: http://www.postgresql.org/idocs/index.php?sql-createtable.html

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group