Re: Search the schema

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Search the schema
Date: 2012-07-19 10:40:13
Message-ID: CAGCvxeYK3ksF1cfbKFCEhpx1wokFuMJzW2ADhoq=Fx+_U_jspQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)lelarge(dot)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.
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Nelson A. de Oliveira 2012-07-19 14:39:54 Edit data on the data output tab
Previous Message Guillaume Lelarge 2012-07-19 08:13:17 Re: Search the schema