I noticed that when changing the query definition of a Materialized View (using the view Properties > Definition tab), it always generates an error:
An error has occurred:
ERROR: syntax error at or near ")"
LINE 3: )
This appears to be due to the addition of the following to the SQL statement:
WITH (
)
After unchecking "Read Only" and deleting the above text, it works fine. It happens on any materialized view I've tried (several) and seemingly with any change to the definition (no other changes).
Version 1.22.0
Postgres 9.5.1
Windows 7 64-bit
Thank you.