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 8896ED1B438 for ; Thu, 8 Jan 2004 17:36:43 +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 11567-02 for ; Thu, 8 Jan 2004 13:35:55 -0400 (AST) Received: from fetter.org (dsl092-188-065.sfo1.dsl.speakeasy.net [66.92.188.65]) by svr1.postgresql.org (Postfix) with ESMTP id 2630BD1B480 for ; Thu, 8 Jan 2004 13:35:49 -0400 (AST) Received: from fetter.org (localhost.localdomain [127.0.0.1]) by fetter.org (8.12.10/8.12.10) with ESMTP id i08HZjqf012816; Thu, 8 Jan 2004 09:35:45 -0800 Received: (from shackle@localhost) by fetter.org (8.12.10/8.12.10/Submit) id i08HZiT0012814; Thu, 8 Jan 2004 09:35:44 -0800 Date: Thu, 8 Jan 2004 09:35:44 -0800 From: David Fetter To: Peter Eisentraut Cc: Jeroen Ruigrok/asmodai , pgsql-docs@postgresql.org Subject: Re: The Tutorial(TM) Message-ID: <20040108173544.GY24788@fetter.org> References: <20040108075229.GE85110@nexus.ninth-circle.org> <20040108123937.GU24788@fetter.org> <200401081807.13777.peter_e@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200401081807.13777.peter_e@gmx.net> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/18 X-Sequence-Number: 2234 On Thu, Jan 08, 2004 at 06:07:13PM +0100, Peter Eisentraut wrote: > David Fetter wrote: > > Expanding on that, putting FK's in "Advanced Features" gives the > > (IME always wrong) impression that they're optional. > > They *are* optional. I disagree. > The first chapter is about getting the data in and out. That is not > optional for using a database. Transactions, views, foreign keys, > primary keys even, and everything else that some people think is > essential for a "real" database are in fact optional. > Remember that the tutorial is intended for people starting from > zero. No, they're not optional. If people see how it's done right, starting from zero, they will not then develop bad habits that have to be un-learned. > Let's not overwhelm them right away. I don't think this will be overwhelming. Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 cell: +1 415 235 3778