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

From Peter Eisentraut
Subject Re: Materialized views WIP patch
Date
Msg-id 51269617.7070401@gmx.net
Whole thread Raw
In response to Re: Materialized views WIP patch  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-hackers
On 2/21/13 9:25 AM, Kevin Grittner wrote:
> Peter Eisentraut <peter_e@gmx.net> wrote:
>> On 2/20/13 11:14 PM, Greg Stark wrote:
>>> That's not entirely true. From the database's point of view,
>>> TRUNCATE is in many ways actually DDL.
>>
>> Whether something is DDL or DML or a read operation (query) is
>> not an implementation detail, it's a user-exposed category. 
>> Since TRUNCATE is logically equivalent to DELETE, it's a DML
>> operation, as far as the user is concerned.
> 
> Not really.  It doesn't follow the same MVCC behavior as DML.  This
> is user-visible, documented behavior.

MVCC behavior does not determine whether something is considered DDL or DML.




pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: bugfix: --echo-hidden is not supported by \sf statements
Next
From: Kevin Grittner
Date:
Subject: Re: Materialized views WIP patch