Обсуждение: ERROR: nodeRead: Bad type 0

Поиск
Список
Период
Сортировка

ERROR: nodeRead: Bad type 0

От
Doo Suk Yang
Дата:
What is that message which appears dropping some table.

My database is malfunctioning in some tables. Can't create table, can't
pg_dump.

===============================================================================
Science is the game we play with God to find out what his rules are.
-------------------------------------------------------------------------------
Doo Suk Yang
Research Scientist                              Voice: 82-42-866-2222
LG Chemical Ltd. Research Park
Biotech Research Institute I                    FAX:   82-42-861-2566
-------------------------------------------------------------------------------
A fool hath no delight in understanding, but that his heart may discover itself.
(Proverbs 18:2)
===============================================================================


Re: [GENERAL] ERROR: nodeRead: Bad type 0

От
James Thompson
Дата:
On Thu, 27 May 1999, Doo Suk Yang wrote:

> What is that message which appears dropping some table.
>
> My database is malfunctioning in some tables. Can't create table, can't
> pg_dump.
>

This has happended to me when updating CVS copies of postgresql.  If
you've updated your postgresql code without doing an dump/initdb/restore
then this might be causing your problems.

Can you use the -t option of pg_dump to dump individual tables?  This
might salvage your data and allow you to re initdb the database and start
anew.  Might give you the perfect excuse to update to 6.5 which I believe
is due out around the first of the month. ;-)

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson    138 Cardwell Hall  Manhattan, Ks   66506    785-532-0561
Kansas State University                          Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<