Re: Problems with dump /restore of views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problems with dump /restore of views
Date: 2002-06-21 17:13:10
Message-ID: 20809.1024679590@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor <rbt(at)zort(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-06-21 17:19:49 Re: Adding encrypted identd authetification
Previous Message Bruce Momjian 2002-06-21 16:51:53 Re: What is wrong with hashed index usage?