Re: Strange issue with CREATE OPERATOR CLASS

Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
>> I've been working on some scripts (for pgfoundry) which help in 
>> "cleaning up" databases which have TSearch and other contrib modules 
>> installed to schema public.  However, I ran into this odd issue:
> 
>> ERROR:  btree operators must return boolean
> 
> Is that the actual error message?  The closest string I can find in 8.3
> or HEAD is "index operators must return boolean".

Oh!  Sorry, this is 8.2.12.  I can't reproduce it in 8.3 for obvious 
reasons, since there the TSearch stuff comes built-in.

> It seems possible that you could get an error like that as a result of
> something creating a shell operator and not filling it in afterwards,
> but if so I'd blame the earlier something; the worst that can be laid at
> CREATE OPERATOR CLASS's door is giving a less helpful error message than
> it could.  We really need to see a complete example of how to reproduce
> the problem before speculating about appropriate fixes.

Yeah, I'm trying to figure out the minimum test case; the one I have now 
contains proprietary client data, and *just* using tsearch2.sql doesn't 
produce the problem.

--Josh