Received: from itd.nrl.navy.mil (s2.itd.nrl.navy.mil [132.250.83.3]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA94564 for ; Thu, 25 Feb 1999 10:21:53 -0500 (EST) (envelope-from holston@itd.nrl.navy.mil) Received: from shell (shell [132.250.83.3]) by itd.nrl.navy.mil (8.8.8/8.8.8) with SMTP id KAA09250; Thu, 25 Feb 1999 10:21:44 -0500 (EST) Date: Thu, 25 Feb 1999 10:21:44 -0500 (EST) From: Gregory Holston X-Sender: holston@shell To: Jan Wieck cc: jwieck@debis.com, pgsql-sql@hub.org Subject: Re: [SQL] Unable to read from a view In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII > > 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; It worked thanks a lot!!! -Greg