From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | REINDEX SYSTEM tables ... index disappearing ... ? |
Date: | 2005-06-13 19:34:40 |
Message-ID: | 20050613163159.V90456@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
'k, I've been playing around with the REINDEX stuff, and either I'm
mis-understanding something, or there is a bug in 7.4.x ...
If I do a:
REINDEX TABLE pg_statistic;
my 'on disk' INDEX is disappearing, altho there is no errors being
generated:
# select oid,relname from pg_class where relname like 'pg_statistic%';
oid | relname
-------+------------------------------
16408 | pg_statistic
16647 | pg_statistic_relid_att_index
(2 rows)
But, on disk:
$ ls -l 16408 16647
ls: 16647: No such file or directory
-rw------- 1 pgsql pgsql 385024 Jun 13 15:28 16408
# reindex table pg_statistic;
REINDEX
#
Shouldn't this work? Or, at least, generate an error message?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | David Siebert | 2005-06-13 19:35:25 | Re: [GENERAL] pg_dumpall not working? |
Previous Message | Marc G. Fournier | 2005-06-13 19:25:29 | VACUUM equivalent to REINDEX DATABASE ? |