Re: invalid memory alloc request size 2147483648 using toode LIKE 'ä%' - Mailing list pgsql-general

> 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.