| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Kragen Sitaker <kragen+pgsql(at)airwave(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: varchar_pattern_ops in 7.3.4? |
| Date: | 2004-01-21 23:54:26 |
| Message-ID: | Pine.LNX.4.33.0401211653460.21832-100000@css120.ihs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 21 Jan 2004, Kragen Sitaker wrote:
> I'd like to be able to do queries like "select count(*), fromline from
> message where subject like 'Couldn%'" quickly. I see that, in current
> Postgres, I can do this with an index like "create index message_subject
> on message using btree(subject varchar_pattern_ops)". But I'm using
> Postgres 7.3.4, and it doesn't seem to have varchar_pattern_ops in its
> pg_opclass.opcname. Is there an easier way to do these queries than
> upgrading?
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-22 00:04:56 | Re: Lost plpgsql function |
| Previous Message | Nigel J. Andrews | 2004-01-21 23:52:37 | Re: embedded/"serverless" (Re: serverless postgresql) |