Re: failed sanity check, table answers was not found - Mailing list pgsql-general

From Marek Pętlicki
Subject Re: failed sanity check, table answers was not found
Date
Msg-id 20010417210010.A932@marek.almaran.home
Whole thread Raw
In response to Re: failed sanity check, table answers was not found  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Travis Bauer
Date:
Subject: Re: JDBC error in 7.0.3
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: gzip and bzip2 (distributing postgresql)