Re: [DOCS] The Tutorial(TM)

[Joshua D. Drake]

Peter Eisentraut wrote: Jeroen Ruigrok/asmodai wrote: Because foreign keys are part of database design 101? Indeed, but the subject matter of chapter 2 of the tutorial is more like introduction to databases 099. Others may rightfully claim that transactions and views are also elementary parts of database application designs, but then there wouldn't be any advanced subjects left. Triggers, rules, name spaces... Foreign keys IMHO should be in a small chapter "About database design" or "Making sure your data is valid" or something. I feel that there is a very useful dividing line between chapters 2 and 3: chapter 2 is about getting the data in and out, to give beginners a feeling that the database system is working, chapter 3 is about refining the data structures for higher convenience, maintainability, and integrity -- "design". ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org