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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
