failed index creation: ERROR: index_formtuple

From: "Nate Teller" <nate(dot)teller(at)mindspring(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: failed index creation: ERROR: index_formtuple
Date: 2004-01-24 17:49:54
Message-ID: KKEOJFLGNNPOJHGFOEFBIEBECNAA.nate.teller@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello -

I've had a nonclustered index on a column of type "character varying(11)"
for many years.
I dropped it and went to recreate the exact same index, but it fails every
time.

create index edata_idx1 on edata (mbrnum);
mbrnum is character varying(11)
number of rows in table: 1326205
postgresql 7.3.4 on Linux 2.4.9-31

ERROR: index_formtuple: data takes 28640 bytes, max is 8191

Any ideas? Any work arounds?

Sincerely,

Nate Teller

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2004-01-24 18:14:23 Re: pl/pgsql docs 37.4.3. Row Types -- how do I use this
Previous Message Andreas 2004-01-24 17:49:07 Is there something like an dynamic view ?