The following bug has been logged on the website:
Bug reference: 14029
Logged by: Rob Flemming
Email address: robf(dot)42(at)gmail(dot)com
PostgreSQL version: 9.3.11
Operating system: Windows 7 Professional
Description:
PgAdmin III truncates reverse engineered SQL script for a materialized view
if it contains a semicolon.
e.g.:
CREATE TABLE hello_tbl (txtcol text);
INSERT INTO hello_tbl VALUES ('Hello'),('World');
CREATE MATERIALIZED VIEW vw_hello AS
SELECT string_agg(txtcol, '; ') FROM hello_tbl;
A view is fine, but with the materialized view all the query after the first
semicolon is dropped.
The materialized view still produces the correct result, but the query text
is lost (unless you save it somewhere else).
Thanks!
pgAdmin Version 1.18.1