ERROR: index row requires 9984 bytes, maximum size is 8191

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: index row requires 9984 bytes, maximum size is 8191
Date: 2011-01-19 22:07:46
Message-ID: AANLkTi==doHqUw=1p8BAMpGY=ffJLhwkZ+Uwus3BAo2t@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all -

I have added a column to a table is which of datatype text. I am
trying to create an index

CREATE OR REPLACE FUNCTION reverse(varchar) RETURNS varchar AS $$
$reversed = reverse $_[0];
return $reversed;
$$ LANGUAGE plperlu IMMUTABLE;

CREATE INDEX rev_email ON users( (reverse(email) ) varchar_pattern_ops );

I am getting the following error ERROR: index row requires 9984
bytes, maximum size is 8191

my logs are not showing any thing else , but the error. Can you please help?

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-01-19 22:11:49 Re: How to fire triggers just on "top" level DML
Previous Message Kevin Grittner 2011-01-19 21:59:48 How to fire triggers just on "top" level DML