Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5F71D2E0046 for ; Tue, 22 Apr 2008 06:45:22 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 40575-06 for ; Tue, 22 Apr 2008 06:45:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gslimes3.sigma.fr (mx.sigma.fr [194.50.39.191]) by developer.postgresql.org (Postfix) with ESMTP id 9387A2E0051 for ; Tue, 22 Apr 2008 06:45:06 -0300 (ADT) Received: from gsw3mes2.groupesigma.fr (unknown [192.168.1.70]) by gslimes3.sigma.fr (Postfix) with ESMTP id BD81136CB3; Tue, 22 Apr 2008 11:45:02 +0200 (CEST) Received: from marc.sigma.fr ([89.195.0.5]) by gsw3mes2.groupesigma.fr with Microsoft SMTPSVC(6.0.3790.3959); Tue, 22 Apr 2008 11:45:02 +0200 From: Marc Cousin Organization: Sigma Informatique To: Tom Lane Subject: Re: cannot restore a view after a dump Date: Tue, 22 Apr 2008 11:45:02 +0200 User-Agent: KMail/1.9.9 Cc: pgsql-admin@postgresql.org References: <200804041022.31746.mcousin@sigma.fr> <18480.1207954866@sss.pgh.pa.us> In-Reply-To: <18480.1207954866@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200804221145.02383.mcousin@sigma.fr> X-OriginalArrivalTime: 22 Apr 2008 09:45:02.0682 (UTC) FILETIME=[898EF3A0:01C8A45D] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/219 X-Sequence-Number: 28983 I've installed it and it works. Thanks a lot. On Saturday 12 April 2008 01:01:06 Tom Lane wrote: > Marc Cousin writes: > > I'm having a strange problem : I created a view in a database, and I > > cannot restore it after a pg_dump. ... > > ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select > > list > > You need this patch: > > http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/arrayf >uncs.c?r1=1.140&r2=1.140.2.1 > > I found that this problem was introduced in 8.2, which may explain why > you'd not seen it before, if you were previously using an older release. > > regards, tom lane