X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 3593ED1B439
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Jan 2004 17:15:32 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 02039-06
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Jan 2004 13:14:42 -0400 (AST)
Received: from hosting.commandprompt.com (216.commandprompt.com
	[207.173.200.216])
	by svr1.postgresql.org (Postfix) with ESMTP id 03944D1C514
	for <pgsql-docs@postgresql.org>; Thu,  8 Jan 2004 13:14:41 -0400 (AST)
Received: from commandprompt.com (clbb-109.saw.net [64.146.135.109])
	(authenticated)
	by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i08HEVg00555;
	Thu, 8 Jan 2004 09:14:31 -0800
Message-ID: <3FFD9020.4080502@commandprompt.com>
Date: Thu, 08 Jan 2004 09:15:12 -0800
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Jeroen Ruigrok/asmodai <asmodai@wxs.nl>,
	David Fetter <david@fetter.org>, pgsql-docs@postgresql.org
Subject: Re: The Tutorial(TM)
References: <TyudnZdaUc0gMWGiXTWc-g@speakeasy.net>
	<200401080722.53433.peter_e@gmx.net>
	<20040108075229.GE85110@nexus.ninth-circle.org>
	<200401081020.00181.peter_e@gmx.net>
In-Reply-To: <200401081020.00181.peter_e@gmx.net>
Content-Type: multipart/alternative;
	boundary="------------010906030808070508070808"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/16
X-Sequence-Number: 2232

This is a multi-part message in MIME format.
--------------010906030808070508070808
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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 


--------------010906030808070508070808
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Peter Eisentraut wrote:<br>
<blockquote cite="mid200401081020.00181.peter_e@gmx.net" type="cite">
  <pre wrap="">Jeroen Ruigrok/asmodai wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Because foreign keys are part of database design 101?
    </pre>
  </blockquote>
  <pre wrap=""><!---->
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.

  </pre>
</blockquote>
Triggers, rules, name spaces...<br>
<br>
Foreign keys IMHO should be in a small chapter "About database design"
or "Making sure your data is valid"<br>
or something.<br>
<br>
<br>
<br>
<blockquote cite="mid200401081020.00181.peter_e@gmx.net" type="cite">
  <pre wrap="">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
  </pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - <a class="moz-txt-link-abbreviated" href="mailto:jd@commandprompt.com">jd@commandprompt.com</a> - <a class="moz-txt-link-freetext" href="http://www.commandprompt.com">http://www.commandprompt.com</a>
Editor-N-Chief - PostgreSQl.Org - <a class="moz-txt-link-freetext" href="http://www.postgresql.org">http://www.postgresql.org</a> </pre>
</body>
</html>

--------------010906030808070508070808--