deleting function from pg_catalog.pg_proc

Поиск
Список
Период
Сортировка
От Gevik Babakhani
Тема deleting function from pg_catalog.pg_proc
Дата
Msg-id 9179.195.169.118.236.1143550725.squirrel@webmail.xs4all.nl
обсуждение исходный текст
Ответы Re: deleting function from pg_catalog.pg_proc  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Hello Folks,

I would like to know if deleting functions from pg_catalog.pg_proc with
the following SQL statement is advisable?

I would like a way of deleting my functions without using the DROP
FUNCTION statement.

------------------------------------------------------------------
delete from pg_catalog.pg_proc where oid in (select sp.oid from
    pg_catalog.pg_proc sp
    inner join pg_namespace ns on sp.pronamespace=ns.oid
where
    ns.nspname='public'
    and sp.proname like 'sys%')
------------------------------------------------------------------
Thank you.



В списке pgsql-general по дате отправления:

Предыдущее
От: "David Welton"
Дата:
Сообщение: Concurrency question
Следующее
От: JP Glutting
Дата:
Сообщение: Re: Bug? was: Re: ERROR: could not convert UTF8 character