pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
bug in tutorial docs
2+ messages / 2 participants
[nested] [flat]

* bug in tutorial docs
@ 2002-06-23 20:30  kbrannen@gte.net
  0 siblings, 1 reply; 2+ messages in thread

From: kbrannen@gte.net @ 2002-06-23 20:30 UTC (permalink / raw)
  To: 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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: bug in tutorial docs
@ 2002-06-25 03:36  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: kbrannen@gte.net
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2002-06-25 03:36 UTC (permalink / raw)
  To: kbrannen@gte.net; +Cc: pgsql-docs


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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-06-25 03:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-23 20:30 bug in tutorial docs kbrannen@gte.net
2002-06-25 03:36 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox