Thread

Re: [HACKERS] view?

Constantin Teodorescu <teo@flex.ro> — 1999-01-22T23:11:07Z

Jan Wieck wrote:
> 
> Jose' Soares wrote:
> 
> > I modified psql.c to use pg_get_viewdef() function to seek for views and
> > now I can display only tables using \dt
>
>  I suggest not to apply this patch
> 
>  1.  The  function  pg_get_viewdef()  is  definitely  too much
>      overhead. In fact it must parse back  the  complete  view
>      .......

I used pg_get_viewdef() function to properly detect views and tables in
PgAccess.
For the moment, I have released a new version 0.94 of PgAccess based on
this and it works fine.

I am sure that you are right concerning pg_get_viewdef() function, but
please, could you tell me another way of detecting views from "false
views" ? relhasrules field isn't good enough for it and for the moment,
pg_get_viewdef() seems to be a good method. If anyone could tell me
another way of safely detecting views I can change it.

Also, I used pg_get_viewdef() in order to get views's definition for the
"Design" view function so, I will need also such a function in order to
implement this feature.

-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA