Hi Wenjing, I hope we need to change the below error message. postgres=# create global temporary table gtt(c1 int) on commit preserve rows; CREATE TABLE
postgres=# create materialized view mvw as select * from gtt; ERROR: materialized views must not use global temporary tables* or views* Anyways we are not allowed to create a "global temporary view", so the above ERROR message should change(i.e. *" or view"* need to be removed from the error message) something like: *"ERROR: materialized views must not use global temporary tables"* -- With Regards, Prabhat Kumar Sahu EnterpriseDB: http://www.enterprisedb.com