X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9C4C052862 for ; Thu, 2 Jun 2005 09:32:52 -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 83571-09 for ; Thu, 2 Jun 2005 12:32:44 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 69C955281C for ; Thu, 2 Jun 2005 09:32:42 -0300 (ADT) Received: (qmail 7734 invoked by uid 500); 2 Jun 2005 12:31:50 -0000 Date: Thu, 2 Jun 2005 07:31:50 -0500 From: Bruno Wolff III To: =?iso-8859-1?Q?K=D6PFERL?= Robert Cc: "'dpandey@secf.com'" , 'Richard Huxton' , pgsql-general@postgresql.org, 'PostgreSQL' Subject: Re: index row size 2728 exceeds btree maximum, 27 Message-ID: <20050602123150.GB6785@wolff.to> Mail-Followup-To: Bruno Wolff III , =?iso-8859-1?Q?K=D6PFERL?= Robert , "'dpandey@secf.com'" , 'Richard Huxton' , pgsql-general@postgresql.org, 'PostgreSQL' References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/85 X-Sequence-Number: 78793 On Thu, Jun 02, 2005 at 14:08:54 +0200, KÖPFERL Robert wrote: > To me it seems that the definer of this table missed the concept index ... > or the concept database > One usually looks up data using a key, but if the whole row is the key, what > data shall be looked up. You sometimes do want to make a whole role a key to avoid duplicate keys. A common case is when you use a table to connect two other tables with a many to many relation. It would be rare to want to do that with large text values though.