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

From Peter Eisentraut
Subject Re: Materialized views WIP patch
Date
Msg-id 51251CA0.9070203@gmx.net
Whole thread Raw
In response to Re: Materialized views WIP patch  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Materialized views WIP patch  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-hackers
On 2/19/13 5:47 PM, Kevin Grittner wrote:
> When I went to do this, I hit a shift/reduce conflict, because with
> TABLE being optional it couldn't tell whether:
> 
> TRUNCATE MATERIALIZED VIEW x, y, z;
> 
> ... was looking for five relations or three.  That goes away with
> MATERIALIZED escalated to TYPE_FUNC_NAME_KEYWORD.  Is that OK?

Is TRUNCATE even the right command here?  For regular tables TRUNCATE is
a fast DELETE, which logically empties the table.  For materialized
views, there is no deleting, so this command (I suppose?) just
invalidates the materalized view.  That's not the same thing.

Are there TRUNCATE triggers on materialized views?




pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Materialized views WIP patch
Next
From: Heikki Linnakangas
Date:
Subject: Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq