Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

PROBLEME mit REINDEX



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group