How to remove view, 'ERROR: nodeRead: Bad type 0'?

Поиск
Список
Период
Сортировка
От erkki.seppala@radiolinja.fi
Тема How to remove view, 'ERROR: nodeRead: Bad type 0'?
Дата
Msg-id Pine.LNX.4.10.9907271112450.23068-100000@ese.om.radiolinja.fi
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Finn Kettner"
Дата:
Сообщение: Re: [GENERAL] PHP and Postgresql 6.5.1
Следующее
От: Jose Miguel Pereira Tavares
Дата:
Сообщение: Re: [GENERAL] PHP and Postgresql 6.5.1