Re: [GENERAL] index row size 2728 exceeds btree maximum, 27 - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: [GENERAL] index row size 2728 exceeds btree maximum, 27
Date
Msg-id 20050602123150.GB6785@wolff.to
Whole thread Raw
In response to Re: [GENERAL] index row size 2728 exceeds btree maximum, 27  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgsql-sql
On Thu, Jun 02, 2005 at 14:08:54 +0200,
  KÖPFERL Robert <robert.koepferl@sonorys.at> 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.

pgsql-sql by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: Re: index row size 2728 exceeds btree maximum, 2713
Next
From: Bruno Wolff III
Date:
Subject: Re: index row size 2728 exceeds btree maximum, 2713