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
Message-ID: <200602262326.k1QNQnH70619@ora.primehs.net> (raw)
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: yfuruse@kobeoffshore.com, alvherre@commandprompt.com
Subject: Re: Relation 0 does not exist
In-Reply-To: <200602262326.k1QNQnH70619@ora.primehs.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox