ERROR: bogus varno

Поиск
Список
Период
Сортировка
От Bricklen Anderson
Тема ERROR: bogus varno
Дата
Msg-id 4322000B.50200@PresiNET.com
обсуждение исходный текст
Ответы Re: ERROR: bogus varno  (Michael Fuhr <mike@fuhr.org>)
Re: ERROR: bogus varno  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
8.1beta1, linux

If I issue a query from a view with a WHERE condition, w/ EXPLAIN ANALYZE, I am
receiving an error:

dev#EXPLAIN ANALYZE select sum(bytes) from user_bw where id=33897;
ERROR:  bogus varno: 205

(user_bw is a VIEW)

If I omit the WHERE condition, or the EXPLAIN ANALYZE, or query directly from a
table, it runs fine. A bug perhaps?

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

В списке pgsql-general по дате отправления:

Предыдущее
От: "Van Tress,Michael J - PGPW"
Дата:
Сообщение: ecpg -C INFORMIX
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: ecpg -C INFORMIX