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 <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] so that your > > message can get through to the mailing list > cleanly > > -- > Martijn van Oosterhout <[EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
