kmh496 <kmh496(at)kornet(dot)net> writes:
> this should be in the FAQ, right?
It probably is ;-). I'm betting you're getting burnt by a non-C locale
setting, per this gotcha:
* The default C locale must be used during initdb because it is not
possible to know the next-greatest character in a non-C locale.
You can create a special text_pattern_ops index for such cases
that work only for LIKE indexing.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Sandy Keathley||Date: 2006-07-18 20:36:43|
|Previous:||From: Alan Hodgson||Date: 2006-07-18 14:52:13|
|Subject: Re: Disk space taken|