Re: cleaning up useless pl/pgsql functions - Mailing list pgsql-sql

From Josh Berkus
Subject Re: cleaning up useless pl/pgsql functions
Date
Msg-id 200306301502.24119.josh@agliodbs.com
Whole thread Raw
In response to Re: cleaning up useless pl/pgsql functions  (Tomasz Myrta <jasiek@klaster.net>)
List 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 BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Michael A Nachbaur
Date:
Subject: Need help creating a BEFORE DELETE trigger
Next
From: Robert Treat
Date:
Subject: help with "delete joins"