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 39888D1B447 for ; Thu, 8 Jan 2004 12:40:36 +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 42749-03 for ; Thu, 8 Jan 2004 08:39:50 -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 39DF2D1B440 for ; Thu, 8 Jan 2004 08:39:38 -0400 (AST) Received: from fetter.org (localhost.localdomain [127.0.0.1]) by fetter.org (8.12.10/8.12.10) with ESMTP id i08Cdcqf012211; Thu, 8 Jan 2004 04:39:39 -0800 Received: (from shackle@localhost) by fetter.org (8.12.10/8.12.10/Submit) id i08Cdbcp012209; Thu, 8 Jan 2004 04:39:37 -0800 Date: Thu, 8 Jan 2004 04:39:37 -0800 From: David Fetter To: Jeroen Ruigrok/asmodai Cc: Peter Eisentraut , pgsql-docs@postgresql.org Subject: Re: The Tutorial(TM) Message-ID: <20040108123937.GU24788@fetter.org> References: <200401080722.53433.peter_e@gmx.net> <20040108075229.GE85110@nexus.ninth-circle.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040108075229.GE85110@nexus.ninth-circle.org> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/10 X-Sequence-Number: 2226 On Thu, Jan 08, 2004 at 08:52:29AM +0100, Jeroen Ruigrok/asmodai wrote: > -On [20040108 07:32], Peter Eisentraut (peter_e@gmx.net) wrote: > >Why? > Because foreign keys are part of database design 101? Yes. Expanding on that, putting FK's in "Advanced Features" gives the (IME always wrong) impression that they're optional. Chris Browne, could you give me a pointer to your patch so we don't step on each other's feet? Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 cell: +1 415 235 3778