Обсуждение: Re: Views, views, views: Summary of Arguments

> FWIW, I don't see the issue as "internal vs external" at all.  What's
> bothering me is whether these views can be considered sufficiently
> more stable and better designed than the physical system catalogs
> to justify recommending that application designers should rely on
> the views instead of the catalogs.  That point doesn't seem to me
> to have been proven.  The recent arguments in favor seem to boil down
to
> "novices will find these easier to use", which is very possibly true,
> but novices don't have the same needs as programs.

Argument 2: they can be dropped or modified.  A few weeks ago I was
complaining about non-priv users being able to see all my source code in
pg_proc.  Problem solved.  Now I can totally shut down pgAdmin for a
class of users if I desire (and I do).

Argument 3: backwards compatibility.  Do you remember how tablespaces
introduction broke pgAdmin?

Merlin

"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Argument 3: backwards compatibility.  Do you remember how tablespaces
> introduction broke pgAdmin?

This argument, at least, is bogus.  See my original comments to Josh:
it is not credible that these views will be significantly more stable
than the underlying catalogs.  We don't change the catalogs on whims;
we change them because we have to in order to make some significant
improvement in functionality.  For instance, if this nested-schema
idea goes in, the proposed views will have to change, or else become
useless for most of the purposes they are being touted for.
        regards, tom lane