Re: Client-requested cast mode to emulate Pg8.2 on v8.3

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;