> 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.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026