Cannot create view with subquery and join clause

Started by Robert Osowieckiover 23 years ago2 messagesbugs
Jump to latest
#1Robert Osowiecki
robson@cavern.pl

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Robert Osowiecki
Your email address : robson@cavern.pl

System Configuration
---------------------
Architecture: Intel Celeron

Operating System : Linux version 2.4.16

PostgreSQL version : PostgreSQL-7.3

Compiler used : egcs-2.91.66

Please enter a FULL description of your problem:
------------------------------------------------

I cannot create a view with subquery and join clase.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

/** this one works OK */

create view VOrderTest as
select
or_order_nr,

(select sum(sp_qty)
from TOrdSpecif
where sp_or_order_nr=or_order_nr)
as or_order_qty
from TOrder;

/** this one fails with
ERROR: find_expr_references_walker: bogus varno 3
*//

create view VOrderTest1 as
select
or_order_nr,

(select sum(sp_qty)
from TOrdSpecif
where sp_or_order_nr=or_order_nr)
as or_order_qty

from TOrder
join TCategory on (true);

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

I've looked at find_expr_references_walker source, but it's all voodoo
to me :-(

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Robert Osowiecki (#1)
Re: Cannot create view with subquery and join clause

Robert Osowiecki <robson@cavern.pl> writes:

/** this one fails with
ERROR: find_expr_references_walker: bogus varno 3

I believe I fixed this yesterday --- see pgsql-general for the patch.

regards, tom lane