BUG #14029: PgAdmin III truncates reverse engineered SQL script for a materialized vw if contains a semicolon

Поиск
Список
Период
Сортировка
От robf.42@gmail.com
Тема BUG #14029: PgAdmin III truncates reverse engineered SQL script for a materialized vw if contains a semicolon
Дата
Msg-id 20160317173956.5173.23917@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14029
Logged by:          Rob Flemming
Email address:      robf.42@gmail.com
PostgreSQL version: 9.3.11
Operating system:   Windows 7 Professional
Description:

PgAdmin III truncates reverse engineered SQL script for a materialized view
if it contains a semicolon.
e.g.:
CREATE TABLE hello_tbl (txtcol text);
INSERT INTO hello_tbl VALUES ('Hello'),('World');
CREATE MATERIALIZED VIEW vw_hello AS
SELECT string_agg(txtcol, '; ') FROM hello_tbl;

A view is fine, but with the materialized view all the query after the first
semicolon is dropped.
The materialized view still produces the correct result, but the query text
is lost (unless you save it somewhere else).
Thanks!
pgAdmin Version 1.18.1

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] pgbench -C -M prepared gives an error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: to_char(OF) is broken