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

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: invalid memory alloc request size 2147483648 using toode LIKE 'ä%'
Date: 2007-07-24 13:44:15
Message-ID: f84vng$1kdd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If index

CREATE UNIQUE INDEX toode_toode_unique_pattern_idx
ON firma1.toode
USING btree
(lower(toode::text) text_pattern_ops);

is dropped, this error does not occur.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-07-24 13:57:52 Re: Slow query but can't see whats wrong
Previous Message Dawid Kuroczko 2007-07-24 13:05:55 varchar does not work too well with IS NOT NULL partial indexes.