Re: pg_class could not be found

From: zhicheng wang <wang_zc(at)yahoo(dot)co(dot)uk>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_class could not be found
Date: 2004-06-05 17:37:55
Message-ID: 20040605173755.90758.qmail@web51002.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
i can see the file 1259 is there and the db apparently
working normal and can be started/stopped OK.

if your tool cannot work on this set of db, does it
mean that the db is problematic? i am realy worried.

thanks in advance for advice.

cheng

--- 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2004-06-05 17:38:03 timestamp outside of bounds
Previous Message NTPT 2004-06-05 17:32:05 Re: Select for update, locks and transaction levels