7.2.1: pg_dump of UNIONed VIEWs broken

Поиск
Список
Период
Сортировка
От Ian Morgan
Тема 7.2.1: pg_dump of UNIONed VIEWs broken
Дата
Msg-id Pine.LNX.4.44.0204220200300.1964-100000@light.webcon.net
обсуждение исходный текст
Ответы Re: 7.2.1: pg_dump of UNIONed VIEWs broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: 7.2.1: pg_dump of UNIONed VIEWs broken  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
PostgreSQL 7.2.1's pg_dump prduces bad SQL for VIEW's.

The SQL for CREATE VIEW as output by pg_dump generates an error, because the
appropriate nesting of SELECTs with parentheses is missing:
ERROR: parser: parse error at or near "SELECT"


Original SQL:

CREATE VIEW "agents" as (
        (
        SELECT DISTINCT
                employees.contact_id
        FROM
                employees
        ORDER BY
                employees.contact_id
        )
UNION
        (
        SELECT DISTINCT
                contractors.contact_id
        FROM
                contractors
        ORDER BY
                contractors.contact_id
        )
);


As output by pg_dump:

CREATE VIEW "agents" as SELECT DISTINCT employees.contact_id FROM employees
ORDER BY employees.contact_id UNION SELECT DISTINCT contractors.contact_id
FROM contractors ORDER BY contractors.contact_id;

As you can see, the nesting is entirely lost.

Regards,
Ian Morgan
--
-------------------------------------------------------------------
 Ian E. Morgan        Vice President & C.O.O.         Webcon, Inc.
 imorgan@webcon.net         PGP: #2DA40D07          www.webcon.net
    *  Customized Linux network solutions for your business  *
-------------------------------------------------------------------

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

Предыдущее
От: Michael Loftis
Дата:
Сообщение: Re: PostgreSql Installation
Следующее
От: Gerhard Häring
Дата:
Сообщение: Re: Escaping of special characters in ARRAYs is broken