Thread: bug in documentation

bug in documentation

From
Caspar Bothmer
Date:
My name: Caspar
Email: caspar@cbothmer.org

Description in Documentation:

the 7.2-tutorials available online, both formats (US and A4) at

http://www.de.postgresql.org/users-lounge/docs/7.2/tutorial-7.2-A4.pdf

respectively

http://www.de.postgresql.org/users-lounge/docs/7.2/tutorial-7.2-US.pdf

have this error at chapter 3.3 (foreign keys):

in

  CREATE TABLE weather (

it reads

   city  varchar(80) references weather,


but it should be

   city  varchar(80) references cities,


Postgresql creates an

ERROR:  PRIMARY KEY for referenced table "weather" not found

so the only affect will be that someone trying it out would have to
think about this problem. The error is an obvious one, I read through
the docs and was sure that this wouldn't be ok and just tried it out
myself to verify my first impression.


There is an error message given with the INSERT example right there but
it is trunkated ("not foun") so one can't see whether is reads "not
found in weather" or "not found in cities". If your source says weather
I would recommend changing it there as well.


bye

caspar

Re: bug in documentation

From
Tom Lane
Date:
Caspar Bothmer <caspar@cbothmer.org> writes:
> it reads
>    city  varchar(80) references weather,
> but it should be
>    city  varchar(80) references cities,

This is already fixed in development sources --- see
http://developer.postgresql.org/docs/postgres/tutorial-fk.html
But thanks for the report.

            regards, tom lane