Re: pg_class could not be found

Thanks Martijn

if i dump the db (pg_dumpall), the delete the pgsql
dir, start a new pgsql dir, the import with template1,
this error gone and the db can be checked by your
excelent tool.

also what is

--Table arraytype.. Unknown type

thanks

--- Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> Sigh. Sorry, that tool really needs some TLC to get
> it working across
> all the versions of PostgreSQL I don't have access
> to. It's looking for
> pg_class and is assuming it's OID 1259 and trying to
> open that file.
> Evidently it's failing.
>
> You'd need to indicate the version of the database,
> maybe strace it to
> see where it's going wrong.
>
> Hope this helps,
>
> On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng
> wang wrote:
> > hi,
> >
> > has any one used Martijn van Oosterhout's
> PostgreSQL
> > table checker and dumper (pgfsck, at
> > http://svana.org/kleptog/pgsql/pgfsck.html)?
> >
> > i ran this again my database and it gives this
> error:
> >
> > Couldn't find relation pg_class(1259)
> >
> > does any one know what this is about
> >
> > cheng
> >
> >
> > =====
> > Best wishes
> > Z C Wang
> >
> >
> >
> >
> >
> >
>
____________________________________________________________
> > Yahoo! Messenger - Communicate instantly..."Ping"
> > your friends today! Download Messenger Now
> > http://uk.messenger.yahoo.com/download/index.html
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please
> send an appropriate
> > subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list
> cleanly
>
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org>
> http://svana.org/kleptog/
> > Patent. n. Genius is 5% inspiration and 95%
> perspiration. A patent is a
> > tool for doing 5% of the work and then sitting
> around waiting for someone
> > else to do the other 95% so you can sue them.
>

> ATTACHMENT part 2 application/pgp-signature

=====
Best wishes
Z C Wang

____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html