Re: invalid memory alloc request size 2147483648 using t oode LIKE 'ä%'

["Andrus" <kobruleht2(at)hot(dot)ee>]

> This looks like a problem already reported, and patched here:
> http://archives.postgresql.org/pgsql-committers/2007-05/msg00088.php
> but that fix hasn't made it into any released version yet.

Thank you.

I fixed it in my application by changing index to upper() instead of lower :

CREATE UNIQUE INDEX toode_toode_unique_pattern_idx1
 ON firma1.toode
 USING btree
 (upper(toode::text) text_pattern_ops);

and using

SELECT * FROM firma1.toode WHERE upper(toode)  LIKE 'Ä%'

Will this work OK ?

Andrus.