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

On 25/03/2008, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Anton Melser" <melser(dot)anton(at)gmail(dot)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;