REINDEX SYSTEM tables ... index disappearing ... ?

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

Responses

Browse pgsql-hackers by date

  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 ?