Re: Views, views, views! (long)

On Wed, 4 May 2005 21:37:40 -0700, Josh Berkus <josh(at)agliodbs(dot)com>
wrote:
>As stated above, these system views, once incorporated into a pg distribution,
>are likely to be with us *forever*.

I don't think that this is doable. :-(

You might want to put the system views into a version specific schema,
say pg_views81. The next PG version will contain a new schema
pg_views82 plus a version of 8.1 views that have been adapted to new
features and catalog structures as far as possible without breaking
compatibility. Ideally the views in pg_views81 and pg_views82 will
look the same, but most likely there will be some differences. In PG
8.3 we will have schemas pg_views81, pg_views82, and pg_views83 ...

Obviously it will get harder and harder to maintain older system view
schemas with each new Postgres version. If in PG 8.7 it becomes clear
that carrying on pg_views81 doesn't make sense any more, you simply
drop it. By that time tool vendors should have had enough time to
make their tools compatible with pg_views8x, for some x >= 2.

Servus
Manfred