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<
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 |