PROBLEME mit REINDEX

From: "Roland Moormann (rm)" <roland-moormann(at)versanet(dot)de>
To: pgsql-de-allgemein(at)postgresql(dot)org
Subject: PROBLEME mit REINDEX
Date: 2006-07-11 08:49:27
Message-ID: 200607111049.27725.roland-moormann@versanet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-de-allgemein

transport=# \d mo2db
Table "public.mo2db"
Column | Type | Modifiers
--------------------+-----------------------------+---------------------------------------------
msgid | integer | not null default
nextval('seq_mo2db'::text)
contractid | integer | not null
date | timestamp without time zone | not null
keyword | character varying(16) | not null
originatingaddress | character varying(16) | not null
phone | character varying(16) | not null
sms | character varying(160) | not null
subscr_status | character varying(16) |
subscr_service | character varying(32) |
tariffclass | character varying(8) |
userid | smallint | not null
carrier | character varying(24) | not null
carrierid | smallint | not null
flag | character(1) | not null
sflag | character(1) | not null
Indexes:
"mo2db_pk" PRIMARY KEY, btree (msgid)
"mo2db_idx02" btree (originatingaddress)
"mo2db_idx03" btree (date)
"mo2db_idx04" btree (flag)
"mo2db_idx05" btree (sflag)

transport=# \help reindex
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]

transport=# reindex table mo2db;
ERROR: could not access status of transaction 7
DETAIL: could not open file "/u04/pgdata/data/pg_clog/0000": No such file or
directory

Was ist hier passiert? Wie kann ich den Fehler beheben?

Dank und Gruß,
Roland
--
Roland Moormann
Im Uhlenbruch 69
D-44627 Herne
Germany
Phone: 0049 2323 380 394
Mobile: 0049 178 49 33 789

Responses

Browse pgsql-de-allgemein by date

  From Date Subject
Next Message Tobias Bußmann 2006-07-12 09:29:12 Datum mit deutschem locale formatieren?
Previous Message A. Kretschmer 2006-07-05 15:10:12 Re: Sy