Peter Eisentraut <peter_e@gmx.net> wrote:
> I suppose one should be able to expect that if one finds a view
> in the information schema, then one should be able to use DROP
> VIEW to remove it. Which in this case wouldn't work. So I don't
> think including a materialized view under views or tables is
> appropriate.
Right. I think adding pg_matviews covers the stated use-case
enough to answer Erik's concern. I'm not going to mess with adding
non-standard stuff to the standard views.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company