Re: problem with view in 7.3

"Alphasoft" <ico@alphasoft-bg.com> writes:
> In 7.3 when i am trying to recreate the view I received the folowing error :
> find_expr_references_walker: bogus varno 8

Found it --- thanks for the test case.  The patch is attached, if you
want to apply it locally.
        regards, tom lane


*** src/backend/catalog/dependency.c.orig    Sat Sep 21 20:37:09 2002
--- src/backend/catalog/dependency.c    Wed Dec  4 14:45:58 2002
***************
*** 789,794 ****
--- 789,799 ----         else if (rte->rtekind == RTE_JOIN)         {             /* Scan join output column to add
referencesto join inputs */
 
+             List   *save_rtables;
+ 
+             /* We must make the context appropriate for join's level */
+             save_rtables = context->rtables;
+             context->rtables = rtables;             if (var->varattno <= 0 ||                 var->varattno >
length(rte->joinaliasvars))                elog(ERROR, "find_expr_references_walker: bogus varattno %d",
 
***************
*** 796,801 ****
--- 801,807 ----             find_expr_references_walker((Node *) nth(var->varattno - 1,
                     rte->joinaliasvars),                                         context);
 
+             context->rtables = save_rtables;         }         return false;     }