Postgres Pro
Downloads
Home   >   mailing lists

Re: BYTEA, indexes and "like" - Mailing list pgsql-general

From Tom Lane
Subject Re: BYTEA, indexes and "like"
Date
Msg-id 8866.1029710482@sss.pgh.pa.us
Whole thread Raw
In response to Re: BYTEA, indexes and "like"  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Tree view 
Joe Conway <mail@joeconway.com> writes:
> parts=# select * from bombytea where parent_part = 'FM04-13100-1';
> ERROR:  Index bombytea_idx1 is not a btree

> I'm trying to figure out why right now.

FWIW, I'm not seeing that here... perhaps a clean rebuild is indicated?

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: BYTEA, indexes and "like"
Next
From: GB Clark
Date:
Subject: Re: Triggers - with a little change