agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Alan.Hargreaves@dap.csiro.au
To: postgres@postgres.Berkeley.EDU
Subject: Problems with pg_time
Date: Thu, 18 Jul 1996 09:48:33 +1200
Message-ID: <199607172348.JAA07908@junior.dap.CSIRO.AU> (raw)
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/
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: Alan.Hargreaves@dap.csiro.au
Subject: Re: Problems with pg_time
In-Reply-To: <199607172348.JAA07908@junior.dap.CSIRO.AU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox