| 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: | Whole Thread | Raw Message | 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 |