Bruce,
This problem with VIEWs was fixed by Jan WiecK on oraround 18th December.
Keith.
Bruce Momjian <maillist@candle.pha.pa.us>
>
> > Hi,
> >
> > I think I need some help here
> >
> > Taking part of the pg_views rule shows it thinks the views
> > are NOT views.
> >
> > postgres=> SELECT relname AS viewname, pg_get_userbyid(relowner) AS
viewowner,
> > pg_get_viewdef(relname) AS definition FROM pg_class WHERE relhasrules;
> > viewname |viewowner|definition
> > ----------+---------+----------
> > pg_user |postgres |Not a view
> > pg_rules |postgres |Not a view
> > pg_views |postgres |Not a view
> > pg_tables |postgres |Not a view
> > pg_indexes|postgres |Not a view
> > (5 rows)
>
> Works in the current development tree.
>
>