Re: Extending System Views: proposal for 8.1/8.2

Tom,

> Any new schemas introduced by PG itself will be named pg_something.
> This is not open to negotiation --- it's what we've promised to users
> to avoid tromping on their schema namespace.

I can see the sense in that.  So, there's four ways I can see to do things:

1) leave the existing views (pg_tables, pg_views, etc.) the way they are 
except for adding columns.   Create new views based on the naming scheme of 
the old.

2) create new views in pg_catalog, using new names.  The problem with this is 
that the most intuitive names (pg_tables, pg_views) are taken by the old 
views and I'm not sure what to name the new ones.

3) create a new schema with the system views in it, called for example 
pg_system_views.   This seems cluttered to me; a whole new schema just for a 
dozen views?  

4) ignore backwards compatibility and just re-write the old views.   I can 
hear the shouting already ...

So, a choice of annoying options.   Does anyone else on the channel have 
opinions?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco