Re: refresh materialized view concurrently - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: refresh materialized view concurrently
Date
Msg-id 1371482473.75331.YahooMailNeo@web162904.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: refresh materialized view concurrently  (Nicolas Barbier <nicolas.barbier@gmail.com>)
Responses Re: refresh materialized view concurrently  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Nicolas Barbier <nicolas.barbier@gmail.com> wrote:
> 2013/6/17 Heikki Linnakangas <hlinnakangas@vmware.com>:

>
>> +                                errmsg("concurrent refresh requires a
>> unique index on just columns for all rows of the materialized view")));
>
> Maybe my english is failing me here, but I don’t understand the “just” part.

It means that the index must not use any expressions in the list of
what it's indexing on -- only column names.  Suggestions for better
wording would be welcome.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Stefan Drees
Date:
Subject: Re: matview incremental maintenance
Next
From: Robert Haas
Date:
Subject: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls