Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Function management in PG

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "Robins Tharakan" <tharakan(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Function management in PG
Date: 2008-10-02 16:12:46
Message-ID: 200810021212.47067.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-hackers
On Tuesday 30 September 2008 02:19:31 Robins Tharakan wrote:
> 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.
>

Well, phppgadmin (1) already shows comments for functions in its function 
listing, so you could put tagging there (and i think our search feature 
searches comments as well). A patch adding volitility and security (definer|
caller) info into the listing screen would probably be accepted :-)

> 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.
>

if you don't due a lot of function overloading, getddl (2) can be used to push 
function code into subversion... thats more code management than api 
management, but might be helpful. (note, getddl is still pretty rough around 
the edges). 

(1) http://phppgadmin.sourceforge.net/
(2) https://labs.omniti.com/trac/pgsoltools/wiki/getddl

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

pgsql-hackers by date

Next:From: Joshua DrakeDate: 2008-10-02 16:13:38
Subject: Re: Block-level CRC checks
Previous:From: Aidan Van DykDate: 2008-10-02 16:05:59
Subject: Re: Block-level CRC checks

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2008-10-07 12:26:09
Subject: Re: Buglets in dlgFunction
Previous:From: Dave PageDate: 2008-10-02 08:53:39
Subject: Re: Buglets in dlgFunction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group