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<