ERROR: index row requires 9984 bytes, maximum size is 8191 - Mailing list pgsql-general

From akp geek
Subject ERROR: index row requires 9984 bytes, maximum size is 8191
Date
Msg-id AANLkTi==doHqUw=1p8BAMpGY=ffJLhwkZ+Uwus3BAo2t@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: index row requires 9984 bytes, maximum size is 8191
List 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

pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: How to fire triggers just on "top" level DML
Next
From: Adrian Klaver
Date:
Subject: Re: How to fire triggers just on "top" level DML