Craig Ringer, 17.09.2011 02:28:
> On 09/17/2011 05:47 AM, Stefan Keller wrote:
>> A (read-only) view should behave like a table, right?
>>
>>> CREATE INDEX t1_idx ON t1 (rem);
>> ERROR: »v1« not a table
>> SQL state: 42809
>>
>> => Why should'nt it be possible to create indexes on views in PG?
>
> It's not so much that it's not allowed, as that it's not implemented and not very practical for non-materialized views.
AFAIK: "indexed view" is simply Microsoft's term for "materialized view"
Thomas