X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 069FE9DCC76 for ; Sat, 25 Feb 2006 11:24:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95145-08 for ; Sat, 25 Feb 2006 11:24:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by postgresql.org (Postfix) with ESMTP id 495B79DCC75 for ; Sat, 25 Feb 2006 11:24:12 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 25 Feb 2006 12:44:40 -0300 X-IronPort-AV: i="3.99,385,1131332400"; d="scan'208"; a="31060961:sNHT24889452" Received: from alvh.no-ip.org (201.221.201.125) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 43A978FD0083CF5F; Sat, 25 Feb 2006 12:24:16 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id B1A97C2C2DD; Sat, 25 Feb 2006 12:24:16 -0300 (CLST) Date: Sat, 25 Feb 2006 12:24:16 -0300 From: Alvaro Herrera To: Yasuhiro Furuse Cc: pgsql-sql@postgresql.org Subject: Re: Relation 0 does not exist Message-ID: <20060225152416.GB4756@surnet.cl> Mail-Followup-To: Yasuhiro Furuse , pgsql-sql@postgresql.org References: <200602250706.k1P76sH49189@ora.primehs.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200602250706.k1P76sH49189@ora.primehs.net> User-Agent: Mutt/1.5.11+cvs20060126 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.578 required=5 tests=[AWL=-0.341, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.578 X-Spam-Level: * X-Archive-Number: 200602/315 X-Sequence-Number: 24325 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.