| From: | Kragen Sitaker <kragen+pgsql(at)airwave(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Kragen Sitaker <kragen+pgsql(at)airwave(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: varchar_pattern_ops in 7.3.4? |
| Date: | 2004-01-22 01:15:58 |
| Message-ID: | 20040121171558.K11165@fs.corp.airwave.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-01-22 01:40:07 | Re: Update inside (Insert) Trigger and Unique constraint... |
| Previous Message | Adam Ruth | 2004-01-22 01:07:29 | Re: SCO Extortion |