On 25/03/2008, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Anton Melser" <melser.anton@gmail.com> writes:
>
> >> You'd have to do something like
> >> DELETE FROM pg_operator WHERE oprcode = 'anytextcat'::regproc;
> >> since there isn't any higher-level command that will let you delete a
> >> built-in operator.
> >>
> >> I recommend practicing on a scratch database ;-)
>
> > Thanks for the tip, though alas that didn't seem to fix it...
>
>
> Did you remove the other one too?
Actually, I hadn't even properly deleted the first one (don't know
where I did delete it, but it wasn't in the right place!) :-(. This is
not my day! The app appears to be working again now. I won't bother
you again with this - promised!
Thanks a million.
Cheers
Anton
ps for reference...
DELETE FROM pg_operator WHERE oprcode = 'anytextcat'::regproc;
DELETE FROM pg_operator WHERE oprcode = 'textanycat'::regproc;