How to remove view, 'ERROR: nodeRead: Bad type 0'? - Mailing list pgsql-general

From erkki.seppala@radiolinja.fi
Subject How to remove view, 'ERROR: nodeRead: Bad type 0'?
Date
Msg-id Pine.LNX.4.10.9907271112450.23068-100000@ese.om.radiolinja.fi
Whole thread Raw
List pgsql-general
I created a view with a name "usable bscs" with pgaccess. Apparently pgsql
doesn't support spaces in the views or then there was some other problem..
Anyway, the view is inaccessible. Attempts to access it with select or \d
cause error

  ERROR:  nodeRead: Bad type 0

Is there a way to remove it? My biggest problem is that pg_dump doesn't
work, because it tries to access that too. (Otherwise I would've already
dumped it, modified to dump and then restored it..) One option would be to
modify pg_dump to exclude that view, and then drop the database but I'd
like to avoid that..

 -- erkki


pgsql-general by date:

Previous
From: "Finn Kettner"
Date:
Subject: Re: [GENERAL] PHP and Postgresql 6.5.1
Next
From: Jose Miguel Pereira Tavares
Date:
Subject: Re: [GENERAL] PHP and Postgresql 6.5.1