Syntax error when modifying materialized view

From: Petr Vejsada <osm(at)propsychology(dot)cz>
To: pgadmin-support(at)postgresql(dot)org
Subject: Syntax error when modifying materialized view
Date: 2014-10-27 17:54:45
Message-ID: 2181317.vWxqYNjJz0@mrnous
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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<

Browse pgadmin-support by date

  From Date Subject
Next Message Robert Bisom 2014-10-28 16:06:54 ssl connection with key with password
Previous Message Akshay Joshi 2014-10-27 10:58:06 Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3