On 25/03/2008, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Anton Melser" <melser.anton@xxxxxxxxx> 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; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
