Postgres Pro
Downloads
Home   >   mailing lists

failed index creation: ERROR: index_formtuple - Mailing list pgsql-general

From Nate Teller
Subject failed index creation: ERROR: index_formtuple
Date
Msg-id KKEOJFLGNNPOJHGFOEFBIEBECNAA.nate.teller@mindspring.com
Whole thread Raw
Responses Re: failed index creation: ERROR: index_formtuple  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Ezra Epstein"
Date:
Subject: Re: If table A value IS NULL then table B
Next
From: Brsa@gmx.at (Erwin Brandstetter)
Date:
Subject: Re: UNICODE-encoded database does not accept umlaut-characters (solved)