Re: pg_group_name_index corrupt?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_group_name_index corrupt?
Дата
Msg-id 23800.957452534@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_group_name_index corrupt?  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: pg_group_name_index corrupt?  (The Hermit Hacker <scrappy@hub.org>)
Re: pg_group_name_index corrupt?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
The Hermit Hacker <scrappy@hub.org> writes:
>>>> This worry anyone? :)
>>>> 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.

It occurred to me that this would be the likely symptom if a CREATE
GROUP or ALTER GROUP command had neglected to update the indexes on
pg_group.  However, I can't spot any such problem in the code nor
cause it to happen by hand.  Anyone else have an idea?

BTW Marc, do you happen to know what sequence of user and/or group
create/alter/drops might have been executed on your setup?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: AW: libpq++ build now checks make rc
Следующее
От: Tom Lane
Дата:
Сообщение: Re: system usage stats (Was: Re: Why Not MySQL? )