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