Re: Dropping functions with missing argument types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dropping functions with missing argument types
Дата
Msg-id 9939.1042677485@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Dropping functions with missing argument types  (ddkilzer@theracingworld.com)
Список 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 по дате отправления:

Предыдущее
От: elein
Дата:
Сообщение: Re: String functions like split() and join() in plpgsql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem handling timezones