How to detect views objects ?

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: How to detect views objects ?
Date: 1998-11-14 09:07:59
Message-ID: 364D486F.58566724@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)flex(dot)ro

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 1998-11-14 13:16:33 Re: [HACKERS] More CORBA and PostgreSQL
Previous Message Bruce Momjian 1998-11-14 07:35:26 Re: [HACKERS] More PostgreSQL+CORBA