Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.2/8.9.1) with SMTP id EAA60391 for ; Thu, 25 Feb 1999 04:01:45 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@hub.org id m10Fwhq-000EBPC; Thu, 25 Feb 99 10:03 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] Unable to read from a view To: holston@itd.nrl.navy.mil (Gregory Holston) Date: Thu, 25 Feb 1999 10:03:41 +0100 (MET) Cc: jwieck@debis.com, pgsql-sql@hub.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Gregory Holston" at Feb 24, 99 05:03:18 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > > > On Wed, 24 Feb 1999, Jan Wieck wrote: > > > > > > > > > > Hi all, > > > > > > I just created a view and have been unable to read from it. I am > > > Apache/1.3.1 (Unix) PHP/3.0.3 and Postgres 6.4. When I tried to do a > > > select it gives the following error message: > > > > > > real=> select * from pubsearch; > > > ERROR: nodeRead: Bad type 0 > > > > > > I created the view with the following select statment: > > > > > > select distinct users.firstname, users.lastname, publication.title, > > ^^^^^^^^ > > > > DISTINCT isn't supported in view definitions. You can SELECT > > from view's distinct, but you cannot define them to be. Nor > > could you define views with group by and order by. > > I have tried to drop the view and it gives the same error message. Is > there any way to get rid of them (2). Don't know if it really works for you (I can't reproduce the problem shortly), but try this as postgres superuser: DELETE FROM pg_rewrite WHERE rulename = '_RETpubsearch'; DROP TABLE pubsearch; 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) #