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 QAA11105 for postgres-redist; Wed, 17 Jul 1996 16:48:45 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199607172348.QAA11105@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 junior.dap.CSIRO.AU (root@junior.dap.CSIRO.AU [130.155.96.219]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id QAA07742 for ; Wed, 17 Jul 1996 16:48:43 -0700 Received: from junior.dap.CSIRO.AU (alan@localhost [127.0.0.1]) by junior.dap.CSIRO.AU (8.7.3/8.7.3) with SMTP id JAA07908 for ; Thu, 18 Jul 1996 09:48:35 +1000 (EST) Message-Id: <199607172348.JAA07908@junior.dap.CSIRO.AU> X-Mailer: exmh version 1.6 4/21/95 To: postgres@postgres.Berkeley.EDU Subject: Problems with pg_time From: Alan.Hargreaves@dap.csiro.au Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Thu, 18 Jul 1996 09:48:33 +1200 X-Sender: alan@dap.csiro.au Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Wed, 17 Jul 96 16:48:45 -0700 Resent-XMts: smtp I have my help desk software using postgres as a back end, and I am getting the following error. Last time this happened I had to clean out all my databases and rebuild them from scratch. I'd really prefer not to do this again. Can anyone give me some idea of what is actually happening and how I can fix it? By the way, the error I get with this vacuum command is typical of the errors. POSTGRES backend interactive interface 1.174 1994/06/28 18:04:28 > vacuum StartTransactionCommand() at Thu Jul 18 09:22:33 1996 ProcessUtility() at Thu Jul 18 09:22:33 1996 WARN:Jul 18 09:22:33:cannot open segment 1 of relation pg_time AbortCurrentTransaction() at Thu Jul 18 09:22:33 1996 NOTICE:Jul 18 09:22:33:AbortTransaction and not in in-progress state POSTGRES backend interactive interface 1.174 1994/06/28 18:04:28 > EOF alan. -- Alan Hargreaves (VK2KVF) Alan.Hargreaves@dap.csiro.au, Ph: +61 2 413 7752 CSIRO Division of Applied Physics, PO Box 218 Lindfield 2070 http://www.dap.csiro.au/~alan/ PGP 2.6 key available A billion dollars to sell Windows '95 is revolting. Dr David Suzuki ============================================================================== 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/