Syntax error on Change of Materialized View definition

From: Matthew Syphus <MSyphus(at)lhtac(dot)org>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Syntax error on Change of Materialized View definition
Date: 2016-02-26 22:04:09
Message-ID: 9A88082E9F46DF469E9FBDE7788104470127D535@lhtacexch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Browse pgadmin-support by date

  From Date Subject
Next Message Shailesh Doshi 2016-03-02 18:14:13 pgAdmin3 1.2.X install on OSX - hangs with CPU at 100%
Previous Message Evgeny Morozov 2016-02-25 14:34:11 SSPI authentication is confusing