deleting function from pg_catalog.pg_proc

From: "Gevik Babakhani" <gevik(at)xs4all(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: deleting function from pg_catalog.pg_proc
Date: 2006-03-28 12:58:45
Message-ID: 9179.195.169.118.236.1143550725.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message JP Glutting 2006-03-28 13:09:44 Re: Bug? was: Re: ERROR: could not convert UTF8 character
Previous Message David Welton 2006-03-28 12:56:24 Concurrency question