transport=3D# \d mo2db
Table "public.mo2db"
Column | Type | Modifi=
ers
--------------------+-----------------------------+--------- ---------------=
---------------------
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=3D# \help reindex
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]

transport=3D# 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Roland Moormann (rm) <roland-moormann [at] versanet.de> schrieb:
> transport=3D# reindex table mo2db;
> ERROR: could not access status of transaction 7
> DETAIL: could not open file "/u04/pgdata/data/pg_clog/0000": No such f=
ile or
> directory
>
> Was ist hier passiert? Wie kann ich den Fehler beheben?

Keine Ahnung, aber existiert das Verzeichnis, die Datei? Zugriffsrechte?


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082=B0, E 13.56889=
=B0

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match