Received: from presence1.observatoiredesmarques.fr (presence1.observatoiredesmarques.fr [212.73.199.68]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8EHdu733346 for ; Fri, 14 Sep 2001 13:39:56 -0400 (EDT) (envelope-from richard@presenceweb.com) Received: from presenceweb.com (gatei.observatoiredesmarques.fr [213.56.32.22]) by presence1.observatoiredesmarques.fr (8.9.1/_ODM_070798) with ESMTP id RAA07829; Fri, 14 Sep 2001 17:40:53 GMT Message-ID: <3BA23EEE.A5DA284B@presenceweb.com> Date: Fri, 14 Sep 2001 19:31:26 +0200 From: Richard NAGY Organization: Presenceweb X-Mailer: Mozilla 4.72 [fr] (X11; U; Linux 2.2.14-6.1.1smp i686) X-Accept-Language: fr, en MIME-Version: 1.0 To: Josh Berkus CC: pgsql-sql@postgresql.org Subject: Re: SQL request change when upgrade from 7.0.2 to 7.1.3 References: Content-Type: multipart/alternative; boundary="------------674646B581473C609A987801" X-Archive-Number: 200109/85 X-Sequence-Number: 4743 --------------674646B581473C609A987801 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Josh Berkus a écrit : > Mr. Nagy, > > > Recently, I have upgraded my postgresql server from 7.0.2 to 7.1.3. > > But, > > now, one request which was 'good' before, don't want to work any more > > now. > > I'm not sure I understand your question. What do you mean "doesn't > work"? Please give a detailed list of all steps taken, including any > error messages received. > > > Now, if I want that my request works well, I have to remove the order > > by > > statement. But, of course, it is not ordered any more. > > Er, by "request" do you mean "query"? > > Using an ORDER BY statement as you appear to use it in that query is > permitted and correct. I suspect that your problem is located somewhere > else. For example, what interface tool are you using to send queries to > the database? > > -Josh > > ______AGLIO DATABASE SOLUTIONS___________________________ > Josh Berkus > Complete information technology josh@agliodbs.com > and data management solutions (415) 565-7293 > for law firms, small businesses fax 621-2533 > and non-profit organizations. San Francisco > > Hello Josh BERKUS, Thanks for your answer and sorry for my english. It was a query and not a request! Well, the query works well on postgresql 7.0.2 but when I upgraded the RDBS to 7.1.3, it did not work any more. The error was : Relation e does not exist. But, in the 'order by' statement, I removed the 'e.'. Now, the query works well without any error. It is ordered but I think it is certainly due to the fact that the table was already ordered on disk. So, I have no more errors but I'm not sure that it is completely good. PS : The interface tool that I have used to send queries to the database was psql. Regards -- Richard NAGY Presenceweb --------------674646B581473C609A987801 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Josh Berkus a écrit :
Mr. Nagy,

> Recently, I have upgraded my postgresql server from 7.0.2 to 7.1.3.
> But,
> now, one request which was 'good' before, don't want to work any more
> now.

I'm not sure I understand your question.  What do you mean "doesn't
work"? Please give a detailed list of all steps taken, including any
error messages received.

> Now, if I want that my request works well, I have to remove the order
> by
> statement. But, of course, it is not ordered any more.

Er, by "request" do you mean "query"?

Using an ORDER BY statement as you appear to use it in that query is
permitted and correct.  I suspect that your problem is located somewhere
else.  For example, what interface tool are you using to send queries to
the database?

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco
 
 

Hello Josh BERKUS,

Thanks for your answer and sorry for my english. It was a query and not a request! Well, the query works well on postgresql 7.0.2 but when I upgraded the RDBS to 7.1.3, it did not work any more. The error was : Relation e does not exist.
But, in the 'order by' statement, I removed the 'e.'. Now, the query works well without any error. It is ordered but I think it is certainly due to the fact that the table was already ordered on disk. So, I have no more errors but I'm not sure that it is completely good.

PS : The interface tool that I have used to send queries to the database was psql.

Regards

--
Richard NAGY
Presenceweb
  --------------674646B581473C609A987801--