Re: Re[2]: lower() for varchar data by creating an index - Mailing list pgsql-sql

Alex Guryanow <gav@nlr.ru> writes:
> my-db=> DROP FUNCTION lower(varchar);
> ERROR:  RemoveFunction: function "lower" is built-in

You can get rid of it by deleting the pg_proc tuple directly.  I wonder
though whether RemoveFunction isn't being overly protective --- is there
any good reason not to allow people to delete built-in functions?
Obviously you have only yourself to blame if you delete integer equals
or something equally critical ;-) ... but there are a boatload of
built-ins that are by no means critical.  Comments anyone?
        regards, tom lane