Skip site navigation (1) Skip section navigation (2)

Re: 7.2.1: pg_dump of UNIONed VIEWs broken

From: Ian Morgan <imorgan(at)webcon(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.2.1: pg_dump of UNIONed VIEWs broken
Date: 2002-04-23 21:10:19
Message-ID: Pine.LNX.4.44.0204231708400.21884-100000@light.webcon.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, 23 Apr 2002, Bruce Momjian wrote:

> Can someone phrase a TODO item for me?

How about:
Fix pg_get_viewdef() to output fully nested selects

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



> Ian Morgan wrote:
> > 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.


In response to

pgsql-bugs by date

Next:From: Neil T. SpringDate: 2002-04-23 21:37:31
Subject: pg_dumpall should permit quiet operation
Previous:From: Bruce MomjianDate: 2002-04-23 21:03:14
Subject: Re: 7.2.1: pg_dump of UNIONed VIEWs broken

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group