Re: Materialized views WIP patch
| От | Peter Eisentraut |
|---|---|
| Тема | Re: Materialized views WIP patch |
| Дата | |
| Msg-id | 51251CA0.9070203@gmx.net обсуждение исходный текст |
| Ответ на | Re: Materialized views WIP patch (Kevin Grittner <kgrittn@ymail.com>) |
| Ответы |
Re: Materialized views WIP patch
|
| Список | 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 по дате отправления: