On Wed, Jan 21, 2004 at 04:54:26PM -0700, scott.marlowe wrote:
> On Wed, 21 Jan 2004, Kragen Sitaker wrote:
> > ... subject like 'Couldn%'" ... But I'm using Postgres 7.3.4, and
> > it doesn't seem to have varchar_pattern_ops in its pg_opclass.opcname. ...
>
> The only way to make that version work well here is to dump your database,
> reinitdb with --locate=C and reimport your data. Then the indexes can be
> used without having to have varchar_pattern_ops.
Thank you very much! (I assume you mean --locale=C, not --locate.)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
