Re: [GENERAL] ERROR: index row requires 9984 bytes, maximum size is 8191

2011-01-19 Thread Bill Moran
In response to akp geek : > 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 IMMUT

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

2011-01-19 Thread akp geek
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( (rev