Re: Views, views, views! (long)

On Fri, May 06, 2005 at 09:08:10AM -0400, Robert Treat wrote:
> On Thursday 05 May 2005 23:45, Joshua D. Drake wrote:
> > > I was starting to think this... like this should be a project on foundry
> > > called "enhanced system views" that would be fairly database version
> > > independant and people could install into any databases they needed them
> > > in.
> >
> > You mean like:
> >
> > http://pgfoundry.org/projects/newsysviews/
>
> As Jim points out, their current long term goal is to be a replacement for the
> current system views (hence *new* system views), and the current project was
> created to facilitate development. What I am thinking is that the project
> take on a different goal, mainly that it be an add on that intends to work
> along side the current system views and be both backward and forward
> compatible (hence *enhanced* system views). It's a subtle difference.

What I don't like about that idea (assuming you're intending that these
views are never brought into initdb) is it means that admin tools (like
psql) then either require the user to install the views by hand, or they
don't use them and keep doing things the hard (and error-prone) way.

But yes, the intention is to continue to support backwards compatability
as much as possible. Currently I believe that compatability stops at
versions that don't support schemas, though that could change.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"