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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
