Function management in PG

Поиск
Список
Период
Сортировка
От Robins Tharakan
Тема Function management in PG
Дата
Msg-id 36af4bed0809292319g79f416ffi75f31fc0dc592bc3@mail.gmail.com
обсуждение исходный текст
Ответы Re: [pgadmin-hackers] Function management in PG  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Function management in PG  (Robert Treat <xzilla@users.sourceforge.net>)
Список 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 по дате отправления:

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: parallel pg_restore - WIP patch
Следующее
От: Abbas
Дата:
Сообщение: Re: [REVIEW] Prototype: In-place upgrade v02