Re: URGENT: pg_statistic_relid_att_index has gone
| От | Harald Lau |
|---|---|
| Тема | Re: URGENT: pg_statistic_relid_att_index has gone |
| Дата | |
| Msg-id | 4341399E.3040205@sector-x.de обсуждение исходный текст |
| Ответ на | URGENT: pg_statistic_relid_att_index has gone (Harald Lau <harald@sector-x.de>) |
| Список | pgsql-performance |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > on a 7.2 System (Suse-Linux) I got an error "duplicate key in unique > index pg_statistic_relid_att_index" (think it was while vacuuming) > > I REINDEXd the database. > Now the table pg_statistic_relid_att_index is completely gone. go searching the internet first, man ... Surprisingly I'm not the first one having such a breakdown Found a solution provided by Tom Lane: http://www.xy1.org/pgsql-general@postgresql.org/msg04568.html Seems to work, many thanks Sorry for the overhasty question Harald -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: GnuPT 2.7.2 iQEVAwUBQ0E5nXfX3+fgcdKcAQJWsgf+JvgWRjgl/RLBzGd8wNt7x6/VngGOzdpT 4E3OgbrGuAPEC3INkMLTLRU2hVvjRqgkNaWS2YlXpFmlAff6czGeSbwXv4vDiiH7 AYHpONACLgr8jcHohS0kmylqu/3QYSsmRBDOTOCNms1iMEmJZvpru9YJpSEjwWUL /n5pu5lurcpU+VGLTCikin5UnsNWmQzsegz+f2co3UuTDHIUER+W2538Fb9iiZBD P9TCI972U+oC2YTg+Puh22jPfS1gG7EHUxKt/XbE9klca1AnCdJX6LdsIh7vdMhw 6u8JzaaAz9nHtqYFpClkEpnkp9KEohw/uQyDUCB7FK//MRtSWx+MPw== =52pe -----END PGP SIGNATURE-----
В списке pgsql-performance по дате отправления: