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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general