On http://github.com/pbaros/postgres can be seen changes and my attempt
to implement materialized views. The first commit to the repository
Materialized view can be created, dropped and used in SELECT statement.
CREATE MATERIALIZED VIEW mvname AS SELECT ...;
DROP MATERIALIZED VIEW mvname [CASCADE];
SELECT * FROM mvname;
COMMENT ON MATERIALIZED VIEW mvname IS 'etc.';
Also, I would like to ask for advise if there are rules about specifying
keyword is reserved or unreserved. How I recognize new keywords
MATERIALIZED and REFRESH should be reserved or not.
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2010-06-25 15:49:57|
|Subject: Re: Streaming Replication: sql error on standby|
|Previous:||From: Simon Riggs||Date: 2010-06-25 15:11:03|
|Subject: Re: [COMMITTERS] pgsql: Fix log_temp_files docs and comments to
say bytes not kilobytes.|