Message-Id: <200602262326.k1QNQnH70619@ora.primehs.net>
From: "Yasuhiro Furuse" <yfuruse@kobeoffshore.com>
To: "'Alvaro Herrera'" <alvherre@commandprompt.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: Relation 0 does not exist
Date: Mon, 27 Feb 2006 08:26:46 +0900
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcY6H70+iFod7ejDS9OvYuiyW3Cn8wBCwoUA
In-Reply-To: <20060225152416.GB4756@surnet.cl>

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@postgresql.org 
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Alvaro Herrera
> Sent: Sunday, February 26, 2006 12:24 AM
> To: Yasuhiro Furuse
> Cc: pgsql-sql@postgresql.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@postgresql.org 
> so that your
>        message can get through to the mailing list cleanly
> 
>