From: Joshua D. Drake <jd@commandprompt.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Jeroen Ruigrok/asmodai <asmodai@wxs.nl>
Cc: David Fetter <david@fetter.org>
Cc: pgsql-docs@postgresql.org
Subject: Re: The Tutorial(TM)
Date: Thu, 08 Jan 2004 09:15:12 -0800
Message-ID: <3FFD9020.4080502@commandprompt.com> (raw)
In-Reply-To: <200401081020.00181.peter_e@gmx.net>
References: <TyudnZdaUc0gMWGiXTWc-g@speakeasy.net>
<200401080722.53433.peter_e@gmx.net>
<20040108075229.GE85110@nexus.ninth-circle.org>
<200401081020.00181.peter_e@gmx.net>
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 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: jd@commandprompt.com, peter_e@gmx.net, asmodai@wxs.nl, david@fetter.org
Subject: Re: The Tutorial(TM)
In-Reply-To: <3FFD9020.4080502@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox