Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 942E0475909 for ; Wed, 7 Aug 2002 04:45:02 -0400 (EDT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by postgresql.org (Postfix) with ESMTP id 1B517475841 for ; Wed, 7 Aug 2002 04:45:02 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.36 #2) id 17cMRC-0000IK-0U for pgsql-sql@postgresql.org; Wed, 07 Aug 2002 09:45:03 +0100 Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 9416D134E8 for ; Wed, 7 Aug 2002 09:30:27 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Subject: Re: Limit A Table To 1 Row Date: Wed, 7 Aug 2002 09:30:25 +0100 User-Agent: KMail/1.4.1 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200208070930.25591.dev@archonet.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/127 X-Sequence-Number: 8973 On Wednesday 07 Aug 2002 4:52 am, Josh Berkus wrote: > However, you may want to reconsider this method of storing values in > the database. What I do is create a table called global_admin: > > CREATE TABLE global_admin ( > value_name VARCHAR(30) NOT NULL PRIMARY KEY, > value_format VARCHAR(30) NOT NULL, > admin_value TEXT NULL > ); I do as Josh does (which has got to put some doubts in Josh's mind) except = I=20 add value_section and value_comment fields to make it easier for someone to= =20 edit where necessary. - Richard Huxton