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