Re: Materialized views WIP patch

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Noah Misch <noah(at)leadboat(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Marko Tiikkaja <pgmail(at)joh(dot)to>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Materialized views WIP patch
Date: 2013-02-20 19:35:35
Message-ID: 20130220193535.GL16142@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

* Kevin Grittner (kgrittn(at)ymail(dot)com) wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> > 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.
>
> Hmm.  That's what Greg Stark just said, and I replied that nobody
> else had raised the issue in over three months.  With Greg, that's
> two now.

TRUNCATE MAT VIEW seems like the right command to me. Just my 2c.

Thanks,

Stephen

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2013-02-20 21:25:50 Re: Materialized views WIP patch
Previous Message Kevin Grittner 2013-02-20 19:30:05 Re: Materialized views WIP patch

Browse pgsql-hackers by date

  From Date Subject
Next Message Phil Sorber 2013-02-20 20:16:56 Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq
Previous Message Kevin Grittner 2013-02-20 19:30:05 Re: Materialized views WIP patch