Re: Damaged table "pg_access"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Damaged table "pg_access"
Дата
Msg-id 14900.975423998@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Damaged table "pg_access"  (Jens Hartwig <jhartwig@debis.com>)
Список pgsql-sql
Jens Hartwig <jhartwig@debis.com> writes:
> when I try to access the system-table "pg_class", I get the following
> error:

> zeda=# select * from pg_class;
> NOTICE:  get_groname: group 1 not found
> pqReadData() -- backend closed the channel unexpectedly.

Evidently you had created a group with sysid 1, granted some permissions
on some table to that group, and then deleted the group.  Re-create the
group (CREATE GROUP foo WITH SYSID 1).

I thought the crash in this situation had been fixed long since, but
apparently not :-( ... it still fails in current sources.  I'll make
sure it's fixed for 7.1.
        regards, tom lane


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

Предыдущее
От: "pgsql-sql"
Дата:
Сообщение: Re(2): 7.0.3 BUG
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: Selecting empty columns