From lennart@omnibase.com.au Wed May 15 08:59:35 2002 Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5F7974759EA for ; Wed, 15 May 2002 04:59:35 -0400 (EDT) Received: from mail.iinet.net.au (symphony-06.iinet.net.au [203.59.3.38]) by postgresql.org (Postfix) with SMTP id EB72A475873 for ; Wed, 15 May 2002 04:59:32 -0400 (EDT) Received: (qmail 14732 invoked by uid 666); 15 May 2002 08:59:26 -0000 Received: from unknown (HELO beldin) (203.59.235.2) by iinet.net.au with SMTP; 15 May 2002 08:59:26 -0000 Message-ID: <006101c1fbef$3c1e0380$02eb3bcb@beldin> Reply-To: "Lennart Goedhart" From: "Lennart Goedhart" To: Subject: Typo in PG 7.2.1 Tutorial PDF Date: Wed, 15 May 2002 17:02:26 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005E_01C1FC32.49D31860" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200205/14 X-Sequence-Number: 1372 This is a multi-part message in MIME format. ------=_NextPart_000_005E_01C1FC32.49D31860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Section 3.3 - Foreign Keys CREATE TABLE weather ( city varchar(80) references weather, temp_lo int, temp_hi int, prcp real, date date ); Should read: CREATE TABLE weather ( city varchar(80) references cities, temp_lo int, temp_hi int, prcp real, date date ); Lennart Goedhart ------=_NextPart_000_005E_01C1FC32.49D31860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Section 3.3 - Foreign Keys
 
CREATE TABLE weather (
    city varchar(80) refere= nces=20 weather,
    temp_lo int,
    temp_hi int,
    prcp real,
    date date
);
 
 
Should read:
 
CREATE TABLE= weather=20 (
    city varchar(80) refere= nces=20 cities,
    temp_lo int,
    temp_hi int,
    prcp real,
    date date
);
 
 
Lennart=20 Goedhart
 ------=_NextPart_000_005E_01C1FC32.49D31860-- From pgman@candle.pha.pa.us Thu Jun 6 16:54:16 2002 Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 968D1475A53 for ; Thu, 6 Jun 2002 12:54:16 -0400 (EDT) Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id D1E1A4765C6 for ; Thu, 6 Jun 2002 12:47:56 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g56Glmp20120; Thu, 6 Jun 2002 12:47:48 -0400 (EDT) From: Bruce Momjian Message-Id: <200206061647.g56Glmp20120@candle.pha.pa.us> Subject: Re: Typo in PG 7.2.1 Tutorial PDF In-Reply-To: <006101c1fbef$3c1e0380$02eb3bcb@beldin> To: Lennart Goedhart Date: Thu, 6 Jun 2002 12:47:48 -0400 (EDT) Cc: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200206/10 X-Sequence-Number: 1385 Yes, this is known and fixed. --------------------------------------------------------------------------- Lennart Goedhart wrote: > Section 3.3 - Foreign Keys > > CREATE TABLE weather ( > city varchar(80) references weather, > temp_lo int, > temp_hi int, > prcp real, > date date > ); > > > Should read: > > CREATE TABLE weather ( > city varchar(80) references cities, > temp_lo int, > temp_hi int, > prcp real, > date date > ); > > > Lennart Goedhart -- Bruce Momjian | http://candle.pha.pa.us 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