Re: Relation 0 does not exist

Alvaro

Thak you for your quick reply.

> Hmm. Who knows which one of the data-corrupting unfixed
> known bugs in this ancient version caused this particular

Is this the 'unfixed know bugs' of 7.2.X ? It means the solution
is only upgrading PotgreSQL to 7.3.X ot 7.4.X ?

One more information. I have rebooted the system after this trouble
happens,
I was able to access database normally and error log messsage never
generated.
But I have not tried to run SQL command 'INSERT INTO SDBA2 SELECT * FROM
VHIST2';
since this is the production environment our clients are using now...

> -----Original Message-----
> From: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Alvaro Herrera
> Sent: Sunday, February 26, 2006 12:24 AM
> To: Yasuhiro Furuse
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] Relation 0 does not exist
>
> Yasuhiro Furuse wrote:
>
> > When I run SQL command, I've got the error messe 'Relation
> 0 doesn't exist'
> > and following log messages were generated.
> > After this error happens, I can not access database at all.
> >
> > Could you kindly advise why this kind of error happens?
> >
> > Regards,
> > y.furuse
> >
> >
> ----------------------------------------------------------------------
> > ------
> > ---------------------------------------------------------------
> > [Version]
> > PosrgreSQL7.2.4
>
> Hmm. Who knows which one of the data-corrupting unfixed
> known bugs in this ancient version caused this particular
> problem. I doubt you will find much people trying to figure
> it out; instead, you should be looking into doing an upgrade
> rather soonish.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: 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
>
>