Re: failed sanity check, table answers was not found

On Tuesday, April, 2001-04-17 at 17:05:18, Tom Lane wrote:
> =?iso-8859-2?Q?Marek_P=EAtlicki?= <marpet(at)buy(dot)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(at)buy(dot)pl>