Re: Views, views, views: Summary of Arguments

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Views, views, views: Summary of Arguments
Date: 2005-05-11 17:41:08
Message-ID: 428243B4.9020301@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> To reiterate my point previously: these system views are NOT aimed at the
> people on *this* list; they are for the people on the -NOVICE and -GENERAL
> lists and IRC and the people who don't yet use PostgreSQL. Please stop
> thinking exclusively in terms of whether they would be useful to you,
> personally.

I think the above paragraph is very important. When doing development it
is very easy to think only in terms of what would be useful to you. I
have experienced this quite bit when working on the new book as well. It
is very difficult for me to write a chapter on installing PostgreSQL for
Windows, because for me it is completely useless and fairly, "If you
can't figure it out, you shouldn't be using PostgreSQL" in the first place.

However that is not the case with most of our users. Most of our users
have no clue what is in the pg_ tables or even how to get access to them.

A set of documented views would be very useful in this sense. It would
be a lot easier for someone to say:

select size from large_ojects_metainfo where loid = 12545;

Then the other methods to get the large_object size.

Sincerely,

Joshua D. Drake

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-05-11 18:04:09 Re: 7.3.10 working
Previous Message Andrew Dunstan 2005-05-11 17:16:34 Re: [PATCHES] plperl and pltcl installcheck targets