Re: Search the schema

On Wed, 2012-07-18 at 21:47 -0500, Michael Shapiro wrote:
> What motivated me to ask for this feature was that I was looking to
> see if the dependents/dependencies tabs
> on function would show all the objects that use the function and the
> objects that the functions uses, including other functions, views,
> etc.
> Those relationships, I realize, are not explicitly maintained by
> Postgres, but if PgAdmin could emulate that, it would be great.
> But probably hard, so the search was the next best thing.
>

Hard is not the issue. The dependents/depencies tabs are for
dependencies as given by PostgreSQL. It won't change.

> Given that functions have multiple signatures (same function name with
> a variable number of args), I'd like to be able to find all the places
> that one variant of the function is used. For example if there is a
> function A with two variants: A(int,int) and A(int, text) -- I'd like
> to be able to see where
> A(int, text) is used.
>

That won't happen. It's too complicated. What I can do is search for a
specific string. Begin able to check if A(int, int) is used in this
function, but not function A(int, text) means we need to add something
that will understand the PL/pgsql code. I won't work on that. You can if
you want, but I won't.

The idea I want to work on is to search specific string in a source
code, that's all.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com