Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id HAA11218 for postgres-redist; Tue, 23 May 1995 07:40:04 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199505231440.HAA11218@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from ksv1001.ksc.nasa.gov (ksv1001.ksc.nasa.gov [128.159.152.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id HAA11208 for ; Tue, 23 May 1995 07:40:00 -0700 Received: from sparc2.ksc.nasa.gov by ksv1001.ksc.nasa.gov with SMTP (5.65/25-eef) id AA24108; Tue, 23 May 95 10:37:19 -0400 Received: by sparc2 (4.1/SMI-4.1) id AA15978; Tue, 23 May 95 10:41:38 EDT Date: Tue, 23 May 95 10:41:38 EDT From: sclark%sparc2@ksv1001.ksc.nasa.gov (Sibel Clark) Message-Id: <9505231441.AA15978@sparc2> To: postgres@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Tue, 23 May 95 07:40:04 -0700 Resent-XMts: smtp Hello! Apparently our server went down over the weekend and was started up again on Monday. Now, we have problems running queries with sort options. If we retrieve data without performing a sort, everything works O.K but when we need to do a sort we get the following message: * retrieve (INSPECTION.all) sort by inspno \g Query sent to backend is "retrieve (INSPECTION.all) sort by inspno " WARN:May 23 10:03:56:cannot read block 0 of temp_343168 Any idea why? ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/