Re: Dropping functions with missing argument types - Mailing list pgsql-general

From Tom Lane
Subject Re: Dropping functions with missing argument types
Date
Msg-id 9939.1042677485@sss.pgh.pa.us
Whole thread Raw
In response to Dropping functions with missing argument types  (ddkilzer@theracingworld.com)
List pgsql-general
ddkilzer@theracingworld.com writes:
> What is the best way to delete them?  Am I able to simply identify and
> delete the corresponding rows from the PG_PROC table?

Yup, that should do it.  You will need to be superuser to issue a delete
against pg_proc, but otherwise there's no reason not to.

> Are there any
> other system tables that I need to update if I delete rows from the
> PG_PROC table?

Not unless these were triggers or I/O functions, which I gather they're
not.

            regards, tom lane

pgsql-general by date:

Previous
From: elein
Date:
Subject: Re: String functions like split() and join() in plpgsql
Next
From: Tom Lane
Date:
Subject: Re: Problem handling timezones