Re: [HACKERS] view?

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