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