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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Explain analyze gives bogus varno for dblink views
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding