Re: [HACKERS] Strange issue with CREATE OPERATOR CLASS

2009-02-11 Thread Tom Lane
Josh Berkus writes: > Tom Lane wrote: >> 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. Oh, OK. It's the same case though. Look for operator definitions that specify a commutator or nega

Re: [HACKERS] Strange issue with CREATE OPERATOR CLASS

2009-02-11 Thread Josh Berkus
Tom Lane wrote: Josh Berkus 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

Re: [HACKERS] Strange issue with CREATE OPERATOR CLASS

2009-02-11 Thread Tom Lane
Josh Berkus 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

[HACKERS] Strange issue with CREATE OPERATOR CLASS

2009-02-11 Thread Josh Berkus
All, 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 STATEMENT: CREATE OPERATOR CLASS contrib.tsqu