Re: refresh materialized view concurrently

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: refresh materialized view concurrently
Дата
Msg-id 1371482473.75331.YahooMailNeo@web162904.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: refresh materialized view concurrently  (Nicolas Barbier <nicolas.barbier@gmail.com>)
Ответы Re: refresh materialized view concurrently  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Stefan Drees
Дата:
Сообщение: Re: matview incremental maintenance
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls