Mailbox-Line: From kbrannen@gte.net  Mon Jun 24 08:29:18 2002
Message-ID: <3D162FDE.6030002@gte.net>
Date: Sun, 23 Jun 2002 15:30:22 -0500
From: kbrannen@gte.net
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9) Gecko/20020310
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: bug in tutorial docs
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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