Syntax error when modifying materialized view - Mailing list pgadmin-support

From Petr Vejsada
Subject Syntax error when modifying materialized view
Date
Msg-id 2181317.vWxqYNjJz0@mrnous
Whole thread Raw
List pgadmin-support
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<



pgadmin-support by date:

Previous
From: Akshay Joshi
Date:
Subject: Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3
Next
From: Robert Bisom
Date:
Subject: ssl connection with key with password