Re: failed sanity check, table answers was not found

Поиск
Список
Период
Сортировка
От Marek Pętlicki
Тема Re: failed sanity check, table answers was not found
Дата
Msg-id 20010417210010.A932@marek.almaran.home
обсуждение исходный текст
Ответ на Re: failed sanity check, table answers was not found  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tuesday, April, 2001-04-17 at 17:05:18, Tom Lane wrote:
> =?iso-8859-2?Q?Marek_P=EAtlicki?= <marpet@buy.pl> writes:
> > I receive this error when trying to pg_dump -s
> >     failed sanity check, table answers was not found
>
> I suspect you have a table whose owner no longer exists in pg_shadow.
> Check the pg_class.relowner value for that table, and create a user
> with the matching usesysid.

yes, now I remember messing arround with users...

    update pg_class set relowner=good_one where relowner=bad_one;

worked like charm!

so ma path towards 7.1 is straight and bright now!

thanks and bye!

--
Marek Pętlicki <marpet@buy.pl>


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

Предыдущее
От: Travis Bauer
Дата:
Сообщение: Re: JDBC error in 7.0.3
Следующее
От: teg@redhat.com (Trond Eivind Glomsrød)
Дата:
Сообщение: Re: gzip and bzip2 (distributing postgresql)