How to detect views objects ? - Mailing list pgsql-hackers

From Constantin Teodorescu
Subject How to detect views objects ?
Date
Msg-id 364D486F.58566724@flex.ro
Whole thread Raw
List pgsql-hackers
Today I discovered an astonishing thing !!!

If I declare a rule on a table, PgAccess will not show that table in the
"Tables" panel, but in "Views" panel !!!!!
Even psql, at \dt is showing that my table with rules is a "view?" !!!
:-)

I remember that one year ago, when I started PgAccess development, I
discovered that the only thing that shows me that the object is a view
is the hasrules column.

Today, it seems that I did a HUUUUUGE mistake !

What should I do ? Should I remove completely the "Views" panel from
PgAccess ? Doing so, opening a real view in table browser window, that
will allow inserting and updating in a view! What would worth this ? Is
there any application where inserting in views should help something ?

Any other way to detect "real views" from "real tables with rules
defined on them" ?

Please CC: me directly to teo@flex.ro

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] More PostgreSQL+CORBA
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] More PostgreSQL+CORBA