bug in documentation

My name: Caspar
Email: caspar(at)cbothmer(dot)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

Caspar Bothmer <caspar(at)cbothmer(dot)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