PostgreSQL 7.2 Documentation

Поиск
Список
Период
Сортировка
Искать

PostgreSQL 7.2 Documentation

От:
"Mathias Zajaczkowski" <mathias@ubik.ch>
Дата:

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

 

Re: PostgreSQL 7.2 Documentation

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

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
FAQ