Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with dump /restore of views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problems with dump /restore of views
Date
Msg-id 20809.1024679590@sss.pgh.pa.us
Whole thread Raw
In response to Problems with dump /restore of views  (Rod Taylor <rbt@zort.ca>)
List pgsql-hackers
Tree view 
Rod Taylor <rbt@zort.ca> writes:
> For some reason a view with a select distinct, an order and an exception
> by will cause pg_dump to output a double order by -- one for each select
> which of course is bad SQL.

This is fixed in current sources and REL7_2 branch.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: What is wrong with hashed index usage?
Next
From: Jan Wieck
Date:
Subject: Re: Problems with dump /restore of views