Re: Materialized views WIP patch - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Materialized views WIP patch
Date
Msg-id CA+TgmoajyWDF=+8p1=R51soMqtJ+p25xwTfOC_zgg_UMLCreSQ@mail.gmail.com
Whole thread Raw
In response to Re: Materialized views WIP patch  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
On Wed, Feb 20, 2013 at 11:14 PM, Greg Stark <stark@mit.edu> wrote:
> On Wed, Feb 20, 2013 at 9:25 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
>> More generally, I would consider the invalidation of a materialized view
>> a DDL command, whereas truncating a table is a DML command.
>
> That's not entirely true. From the database's point of view, TRUNCATE
> is in many ways actually DDL.
>
> I actually don't really dislike using "TRUNCATE" for this command.

Me neither.  I'm astonished that we're seriously considering adding
new keywords for this.

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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: posix_fadvise missing in the walsender
Next
From: Peter Eisentraut
Date:
Subject: Re: Materialized views WIP patch