Re: Search the schema - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: Search the schema
Date
Msg-id CAGCvxeYK3ksF1cfbKFCEhpx1wokFuMJzW2ADhoq=Fx+_U_jspQ@mail.gmail.com
Whole thread Raw
In response to Re: Search the schema  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Search the schema
List pgadmin-support
Of course, makes sense, which is why I made the feature request I did (ie, search). Would you consider adding regex expressions to the search?

On Thu, Jul 19, 2012 at 3:13 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
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.

pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Search the schema
Next
From: "Nelson A. de Oliveira"
Date:
Subject: Edit data on the data output tab