From: Tomasz Myrta <jasiek@klaster.net>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: cleaning up useless pl/pgsql functions
Date: Mon, 30 Jun 2003 23:32:08 +0200
Message-ID: <3F00AC58.5070905@klaster.net> (raw)
In-Reply-To: <3F00A7F8.80107@klaster.net>
References: <3F00A7F8.80107@klaster.net>
Dnia 2003-06-30 23:13, Użytkownik Tomasz Myrta napisał:
> Hi
> Do you have any easy script to remove all pl/pgsql function? After a lot
> of changes inside "create or replace function..." scripts I have a big
> mess. I want to remove all user defined pl/pgsql functions and restore
> some of them from my scripts again.
>
>
> Regards,
> Tomasz Myrta
Hmm Answer to myself:
DELETE from pg_proc where prolang =(select oid from pg_language where
lanname='plpgsq');
What do you think about it?
Tomasz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasiek@klaster.net
Subject: Re: cleaning up useless pl/pgsql functions
In-Reply-To: <3F00AC58.5070905@klaster.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox