X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DC51FD1B1BE for ; Fri, 23 Jul 2004 06:33:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25198-09 for ; Fri, 23 Jul 2004 09:33:28 +0000 (GMT) Received: from sharp.noc24x7.com (unknown [69.56.128.138]) by svr1.postgresql.org (Postfix) with ESMTP id 1690DD1B1B3 for ; Fri, 23 Jul 2004 06:33:19 -0300 (ADT) Received: from [61.1.218.214] (helo=thenilgiris.com) by sharp.noc24x7.com with asmtp (Exim 4.34) id 1BnwQe-0004VI-JX; Fri, 23 Jul 2004 15:03:27 +0530 Received: from localhost (localhost [[UNIX: localhost]]) by thenilgiris.com (8.11.2/8.11.2) id i6N7vkL25498; Fri, 23 Jul 2004 13:27:46 +0530 Content-Type: text/plain; charset="iso-8859-1" From: Kenneth Gonsalves To: Karsten Hilbert , pgsql-sql@postgresql.org Subject: Re: surrogate key or not? Date: Fri, 23 Jul 2004 13:27:46 +0530 X-Mailer: KMail [version 1.2] References: <1090325769.3241.27.camel@dicaprio.akademie1.de> <200407221005.59482.josh@agliodbs.com> <20040723085721.C728@hermes.hilbert.loc> In-Reply-To: <20040723085721.C728@hermes.hilbert.loc> MIME-Version: 1.0 Message-Id: <0407231327461F.01150@thenilgiris.com> Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - sharp.noc24x7.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - thenilgiris.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/194 X-Sequence-Number: 18446 On Friday 23 July 2004 12:27 pm, Karsten Hilbert wrote: > BTW, our full schema is here: > > http://www.hherb.com/gnumed/schema/ i was looking at your schema. i'm not a database pro, but in master tables i see you have made the serial id as the primary key. i do it this way: id serial unique name varchar(25) not null primary key is name - after all, you are going to search this on name arent you? or is there some advantage in doing it your way? also, how did you get that neatly formatted output of the schema? -- regards kg http://www.onlineindianhotels.net - hotel bookings reservations in over 4600 hotels in India http://www.ootygolfclub.org