GSoC - code of implementation of materialized views - Mailing list pgsql-hackers

From Pavel Baros
Subject GSoC - code of implementation of materialized views
Date
Msg-id 4C24C751.7030204@seznam.cz
Whole thread Raw
Responses Re: GSoC - code of implementation of materialized views  (Pavel Baros <baros.p@seznam.cz>)
List pgsql-hackers
On http://github.com/pbaros/postgres can be seen changes and my attempt 
to implement materialized views. The first commit to the repository 
implements following:

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;

also works:
COMMENT ON MATERIALIZED VIEW mvname IS 'etc.';
SELECT pg_get_viewdef(mvname);



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.

thanks

Pavel Baros


pgsql-hackers by date:

Previous
From: "Sander, Ingo (NSN - DE/Munich)"
Date:
Subject: Streaming Replication: sql error on standby
Next
From: Robert Haas
Date:
Subject: Re: Streaming Replication: sql error on standby