Received: from mailgate.urz.uni-wuppertal.de (mailgate.urz.uni-wuppertal.de [132.195.20.3]) by hub.org (8.9.1/8.9.1) with ESMTP id IAA08110 for ; Wed, 2 Dec 1998 08:51:42 -0500 (EST) (envelope-from probost@uni-wuppertal.de) Received: from wrin38.urz.uni-wuppertal.de (wrin38.urz.uni-wuppertal.de [132.195.20.38]) by mailgate.urz.uni-wuppertal.de (8.8.8/8.8.8) with SMTP id OAA29850; Wed, 2 Dec 1998 14:51:39 +0100 (MET) Received: from uni-wuppertal.de (localhost [127.0.0.1]) by wrin38.urz.uni-wuppertal.de (950413.SGI.8.6.12/950213.SGI.AUTOCF) via ESMTP id OAA20710; Wed, 2 Dec 1998 14:51:39 +0100 Sender: probost@uni-wuppertal.de Message-ID: <366545EA.4BDB9270@uni-wuppertal.de> Date: Wed, 02 Dec 1998 14:51:38 +0100 From: Karin Probost Organization: BUGH Wuppertal X-Mailer: Mozilla 4.04 [en] (X11; I; IRIX 6.3 IP32) MIME-Version: 1.0 To: Jan Wieck CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Error after creating View References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jan Wieck wrote: > > > > > hallo, > > > > After creating a view i get the message > > ERROR: nodeRead: Bad type 0 > > > > SELECT and VACUUM leads to the same Error. > > > > I am using Postgres 6.3.2 > > > > What's the reason. > > Looks like the rule's action created for the pg_rewrite entry > cannot get parsed back into the internal memory structures. > This is done when the relation is opened and that's why even > VACUUM fails on it. > > I've fixed many things in the rewrite system for v6.4. You > might give it a try. I'm really interested if it works for > v6.4 or if you hit a bug that's still there. > > Jan > > -- > > #======================================================================# > # It's easier to get forgiveness for being wrong than for being right. # > # Let's break this rule - forgive me. # > #======================================== jwieck@debis.com (Jan Wieck) # I'll have the time to upgrade to 6.4 in 1999. ThenI will try again. Thanks. -- MfG ------------------------------------------------------------------------- - Karin Probost - Bergische Universitaet Gesamthochschule Wuppertal - RECHENZENTRUM Raum P-.09.05 - Gaussstr. 20 - D-42097 Wuppertal - Germany - - Tel. : +49 -202 /439 2809 ,Fax -2910 --Email: probost@rz.uni-wuppertal.de --Home : http://www.hrz.uni-wuppertal.de/hrz/personen/k_probost.html -------------------------------------------------------------------------