Function management in PG - Mailing list pgsql-hackers

From Robins Tharakan
Subject Function management in PG
Date
Msg-id 36af4bed0809292319g79f416ffi75f31fc0dc592bc3@mail.gmail.com
Whole thread Raw
Responses Re: [pgadmin-hackers] Function management in PG  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Function management in PG  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Hi,

While making a complex database back-end, I have at-hand about 200 odd functions and frankly 'management of functions' is already getting quite tedious. Since the count is certain to rise, I am looking for a good tool to do this.

By management, I guess I am looking at some kind of tagging mechanism, where it could keep stored a list of tags for each function (tags that I provide, for each new function created) and it be able to provide a comfortable way of searching/browsing through the list.

Originally, I also wished that this could allow me to see whether a given function directly (or indirectly) 'can' change the database, but I guess the 'Volatile' function type suffices my need there. The problem with that is that I still can't see a function's volatility alongside a list of functions. Now making a front-end in PHP seems a few days of work, and although not impossible, I wondered whether this has already been done. 

How do you manage large list of functions (where a hard segregation isn't hard and therefore one can't separate functions based on schemas) ?Any pointers to a Free or Commercial tool would be of immense help.

Thanks,
Robins Tharakan

pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: parallel pg_restore - WIP patch
Next
From: Abbas
Date:
Subject: Re: [REVIEW] Prototype: In-place upgrade v02