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

From Josh Berkus
Subject Re: Materialized views WIP patch
Date
Msg-id 51281492.6060501@agliodbs.com
Whole thread Raw
In response to Re: Materialized views WIP patch  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Materialized views WIP patch  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
> That feels completely wrong to me.  For one thing, I can't think of
> any ALTER commands to populate or remove data.  What did you think
> of the idea of something like DISCARD MATERIALIZED VIEW DATA as a
> new statment?  Or maybe RESET MATERIALIZED VIEW?

I prefer RESET, especially since it could eventually support RESET ALL
MATERIALIZED VIEWS if that turns out to be useful.  How does the parser
like that?

BTW, to contradict Peter E., for my part I would NOT want matview resets
to be logged as DDL.  I would only want matview definitition changes to
be so logged.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Mike Toews
Date:
Subject: Show type in psql SELECT
Next
From: Stephen Frost
Date:
Subject: Re: Strange Windows problem, lock_timeout test request