Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id C782D476BE3 for ; Tue, 25 Jun 2002 00:27:27 -0400 (EDT) Mailbox-Line: From pgman@candle.pha.pa.us Tue Jun 25 00:27:27 2002 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 BF1F247646D for ; Mon, 24 Jun 2002 23:36:31 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g5P3aSC28814; Mon, 24 Jun 2002 23:36:28 -0400 (EDT) From: Bruce Momjian Message-Id: <200206250336.g5P3aSC28814@candle.pha.pa.us> Subject: Re: bug in tutorial docs In-Reply-To: <3D162FDE.6030002@gte.net> To: kbrannen@gte.net Date: Mon, 24 Jun 2002 23:36:28 -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-Spam-Status: No, hits=-3.4 required=5.0 tests=IN_REP_TO version=2.30 X-Spam-Level: X-Archive-Number: 200206/31 X-Sequence-Number: 1406 Yes, this has already been corrected. Thanks. --------------------------------------------------------------------------- kbrannen@gte.net wrote: > Just in case no one else has found it, in the tutorial docs on page > file:/usr/share/doc/packages/postgresql/html/tutorial-fk.html says: > > >>> > CREATE TABLE weather ( > city varchar(80) references weather, > temp_lo int, > temp_hi int, > prcp real, > date date > ); > <<< > > and talks about the foreign key insert error. But that did not work when I > tried it. I believe the doc should say: > > >>> > CREATE TABLE weather ( > city varchar(80) references cities, > temp_lo int, > temp_hi int, > prcp real, > date date > ); > <<< > > The difference is the table referenced, cities not weather. That does allow > the example to work. > > HTH, > Kevin Brannen > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > > -- 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