Re: BYTEA, indexes and "like"

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