Re: cleaning up useless pl/pgsql functions

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: cleaning up useless pl/pgsql functions
Date: 2003-06-30 22:02:24
Message-ID: 200306301502.24119.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tomasz,

> Hmm Answer to myself:
>
> DELETE from pg_proc where prolang =(select oid from pg_language where
> lanname='plpgsq');
>
> What do you think about it?

You probably also want to put a "proowner = {your userid}" condition in there,
just in case there are any builtins/contrib stuff that uses plpgsql.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Treat 2003-06-30 22:26:38 help with "delete joins"
Previous Message Michael A Nachbaur 2003-06-30 21:45:06 Need help creating a BEFORE DELETE trigger