On Mon, Nov 26, 2012 at 04:34:36PM -0500, Kevin Grittner wrote: > David Fetter wrote: > > On Mon, Nov 26, 2012 at 09:46:33AM -0500, Peter Eisentraut wrote: > > >> So, the way I understand it, in Oracle terms, this feature is a > >> "snapshot", not a materialized view. Maybe that's what it should > >> be called then. > > > > "Snapshot" is one of the options for refreshing an Oracle > > materialized view. There are others, which we'll eventually add > > if past is any prologue :) > > That's the way I understand it, too.
Great :) > > I hate to add to the bike-shedding, but we should probably add > > REFRESH SNAPSHOT as an optional piece of the grammar, with more > > REFRESH options to come. > > I would prefer to leave the syntax for refreshing MVs to a later > patch. I'm kind of assuming that SNAPSHOT would be the default if > no other options are specified, but I would prefer not to get into > too much speculation about add-on patches for fear of derailing > this initial effort. You're right. I withdraw my suggestion until such time as this patch (or descendent) is committed and actual working code implementing other refresh strategies is written. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
