From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pg_group_name_index corrupt? |
Date: | 2000-05-04 05:49:14 |
Message-ID: | Pine.BSF.4.21.0005040247350.92638-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This worry anyone? :)
v7.0, compiled today based off of CVS ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
---------- Forwarded message ----------
pg_banners=> vacuum;
NOTICE: Index pg_group_sysid_index: NUMBER OF INDEX' TUPLES (0) IS NOT THE SAME AS HEAP' (1).
Recreate the index.
NOTICE: Index pg_group_name_index: NUMBER OF INDEX' TUPLES (0) IS NOT THE SAME AS HEAP' (1).
Recreate the index.
VACUUM
pg_banners=> \d pg_group
Table = pg_group
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| groname | name | 32 |
| grosysid | int4 | 4 |
| grolist | int4[] | var |
+----------------------------------+----------------------------------+-------+
Indices: pg_group_name_index
pg_group_sysid_index
pg_banners=> \d pg_group_name_index
Table = pg_group_name_index
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| groname | name | 32 |
+----------------------------------+----------------------------------+-------+
pg_banners=> drop index pg_group_name_index;
ERROR: class "pg_group_name_index" is a system catalog index
pg_banners=>
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-05-04 05:51:20 | Re: system usage stats (Was: Re: Why Not MySQL? ) |
Previous Message | Tom Lane | 2000-05-04 05:47:32 | Re: system usage stats (Was: Re: Why Not MySQL? ) |