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
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 |