Thread: Syntax error when modifying materialized view

Syntax error when modifying materialized view

From
Petr Vejsada
Date:
I get syntax error every time trying to modify materialized view.

Pgadmin prepare SQL command somethink like this:

DROP MATERIALIZED VIEW import.someview;CREATE MATERIALIZED VIEW 
import.someview
WITH (
)AS
SELECT foo2.buildings,   foo2.mapped,
...

The "WITH ()" made the syntax error. I've this issue every time, pgAdmin 
version 1.20beta2, but in 1.18.1 I had the same issue.

How to reproduce:
right click on materialized view -> properties, change anything and click OK.

Solution is simple, edit the SQL command a delete "WITH ()", but it's annoying 
and, probably, a bug.

Versions:

pgAdmin 1.20beta2, ./configure

OS Slackware Linux 14.1 (32b), kernel 3.10.42

wxWidgets 2.8.12, ./configure --prefix=/usr/local --with-gtk --enable-gtk2 --
enable-unicode --enable-mimetype

PostgreSQL 9.3.5, ./configure --with-openssl --enable-nls --with-libxml --
with-libxslt

--
Petr
>p<