| 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: | Whole Thread | Raw Message | 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? ) |