Cannot create view with subquery and join clause
От | Robert Osowiecki |
---|---|
Тема | Cannot create view with subquery and join clause |
Дата | |
Msg-id | 3DEF546A.9000009@cavern.pl обсуждение исходный текст |
Ответы |
Re: Cannot create view with subquery and join clause
|
Список | pgsql-bugs |
============================================================================ 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 :-(
В списке pgsql-bugs по дате отправления: