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
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 |