Re: Problems with dump /restore of views

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
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 16:45:20
Message-ID: 3D135820.797AE633@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor wrote:
>
> 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.

I think views should not have ORDER BY clauses at all in the first
place.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-06-21 16:45:48 Re: Reduce heap tuple header size
Previous Message Marc G. Fournier 2002-06-21 16:19:51 Re: Our archive searching stinks