Thread: bug in tutorial 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

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