Re: Materialized views WIP patch

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: Kevin Grittner <kgrittn(at)ymail(dot)com>, Tatsuo Ishii <ishii(at)postgresql(dot)org>, "stark(at)mit(dot)edu" <stark(at)mit(dot)edu>, "ants(at)cybertec(dot)at" <ants(at)cybertec(dot)at>, "hlinnakangas(at)vmware(dot)com" <hlinnakangas(at)vmware(dot)com>, "michael(dot)paquier(at)gmail(dot)com" <michael(dot)paquier(at)gmail(dot)com>, "josh(at)agliodbs(dot)com" <josh(at)agliodbs(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Materialized views WIP patch
Date: 2013-03-08 15:31:30
Message-ID: CA+TgmoYHzsUDUebuQbR8ugvfz+dL1uRYdYEZ+ABbZJcMbmtKiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Thu, Mar 7, 2013 at 12:14 PM, David E. Wheeler <david(at)justatheory(dot)com> wrote:
> On Mar 7, 2013, at 7:55 AM, Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:
>>> If the answer to both those questions is “yes,” I think the term
>>> should remain “table,” with a few mentions that the term includes
>>> materialized views (and excludes foreign tables).
>>
>> And if the answers are "not exactly" and "yes"?
>
> I still tend to think that the term should remain “table,” with brief mentions at the top of pages when the term should be assumed to represent tables and matviews, and otherwise required disambiguations.

This ship has already sailed. There are plenty of places where
operations apply to a subset of the relation types that exist today,
and we either list them out or refer to "relations" generically.
Changing that would require widespread changes to both the
documentation and existing error message text. We cannot decide that
"table" now means "table or materialized view" any more than we can
decide that it means "table or foreign table", as was proposed around
the time those changes went in. Yeah, it's more work, and it's a
little annoying, but it's also clear. Nothing else is.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2013-03-08 19:16:18 Re: pgsql: Correct tense in log message
Previous Message Heikki Linnakangas 2013-03-08 15:13:38 Re: pgsql: SP-GiST support of the range adjacent operator -|-

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-03-08 15:44:09 Re: sql_drop Event Triggerg
Previous Message Robert Haas 2013-03-08 15:26:21 Re: Index Unqiueness