From mathias@ubik.ch Mon Jun 8 11:40:40 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF0454760D7 for ; Mon, 2 Sep 2002 10:44:25 -0400 (EDT) Received: from velan.urbanet.ch (velan.urbanet.ch [195.202.193.140]) by postgresql.org (Postfix) with SMTP id D21AE4760CE for ; Mon, 2 Sep 2002 10:44:24 -0400 (EDT) Received: (qmail 5974 invoked from network); 2 Sep 2002 14:44:34 -0000 Received: from unknown (HELO ASTERIX) (195.202.194.3) by 0 with SMTP; 2 Sep 2002 14:44:34 -0000 Reply-To: From: "Mathias Zajaczkowski" To: Subject: PostgreSQL 7.2 Documentation Date: Mon, 2 Sep 2002 16:43:20 +0200 Message-ID: <71BFB6708920D211967300805F85071C072A73@UBK_SRV1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C2529F.DEB4BE20" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/11 X-Sequence-Number: 1463 C'est un message de format MIME en plusieurs parties. ------=_NextPart_000_0000_01C2529F.DEB4BE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit 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   ------=_NextPart_000_0000_01C2529F.DEB4BE20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

<=
FONT size=3D3>Table weather refernces table cities and not itse=
lf.
Best regards

Mathias Zajaczkowski,
UBIK S.A.
Av. Cortot 7d,=20
1260, Nyon, Switzerland
Tel : +41 22 362 04 60
Fax:= +41 22 362=20 04 61
mailto:mathias@ubik.ch
http://www.ubik.ch

 
------=_NextPart_000_0000_01C2529F.DEB4BE20-- From pgman@candle.pha.pa.us Mon Jun 8 11:40:40 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 552B8475EBA for ; 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 ; 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 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