Skip site navigation (1) Skip section navigation (2)

bug in tutorial docs

From: kbrannen(at)gte(dot)net
To: pgsql-docs(at)postgresql(dot)org
Subject: bug in tutorial docs
Date: 2002-06-23 20:30:22
Message-ID: 3D162FDE.6030002@gte.net (view raw or flat)
Thread:
Lists: pgsql-docs
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




Responses

pgsql-docs by date

Next:From: Bruce MomjianDate: 2002-06-25 03:36:28
Subject: Re: bug in tutorial docs
Previous:From: terryDate: 2002-06-21 11:46:27
Subject: Re: [DOCS] crash problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group