Re: Views, views, views: Summary of Arguments

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: josh(at)agliodbs(dot)com, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Views, views, views: Summary of Arguments
Date: 2005-05-13 18:59:01
Message-ID: 20050513185859.GA49630@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 12, 2005 at 04:03:39PM -0400, Andrew Dunstan wrote:
> I still don't have any strong views, but I do want the target audience
> specified - I have seen conflicting messages on that. Power users? Admin
> Tool builders? Client library builders? These groups don't all have the
> same needs.

While their needs may not be identical, I don't think that means you
can't provide views that serve all of their needs, unless there are
requirements that are in direct opposition to on another. I can't think
of any requirements in your examples that would fall under this
catagory.

Another use case I wanted to mention is using system views to assist in
remote troubleshooting. If you need to know something about someone's
database, it will be much easier to ask them to run a query against the
system views as opposed to the catalog.
--
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?"

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Harris, Richard 2005-05-13 20:43:54 Permissions not removed when group dropped
Previous Message Andrew Dunstan 2005-05-13 18:34:53 Re: Catalog Security WAS: Views, views, views: Summary