Function management in PG

From: "Robins Tharakan" <tharakan(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Function management in PG
Date: 2008-09-30 06:19:31
Message-ID: 36af4bed0809292319g79f416ffi75f31fc0dc592bc3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers 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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Merlin Moncure 2008-09-30 16:59:41 Re: Function management in PG
Previous Message Guillaume Lelarge 2008-09-26 06:46:18 Re: Bug tracker

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2008-09-30 07:08:14 Re: [REVIEW] Prototype: In-place upgrade v02
Previous Message Philip Warner 2008-09-30 04:13:06 Re: parallel pg_restore - WIP patch