| From: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ERROR: bogus varno |
| Date: | 2005-09-09 21:35:07 |
| Message-ID: | 4322000B.50200@PresiNET.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
_______________________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-09-09 21:41:52 | Re: ecpg -C INFORMIX |
| Previous Message | Van Tress,Michael J - PGPW | 2005-09-09 21:18:07 | ecpg -C INFORMIX |