Re: [SQL] problem with view in 7.3

2002-12-04 Thread Tom Lane
"Alphasoft" <[EMAIL PROTECTED]> 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

[SQL] problem with view in 7.3

2002-12-03 Thread Alphasoft
Hi , I am Hristo Neshev From Bulgaria   In Version 7.2 this statement works :   create view v_impr_check(ead_no,ead_date, e_no,e_date,sid,number, s_order,cdt,cdt_description, original_qty,used_qty,waste_qty,rest_qty,original_used_qty)ASselect distinct md_custom_number, md_custom_date, md_nu

Re: [SQL] problem with view in 7.3

2002-12-03 Thread Tom Lane
"Alphasoft" <[EMAIL PROTECTED]> writes: > In 7.3 when i am trying to recreate the view I received the folowing error : > find_expr_references_walker: bogus varno 8=20 This is a bug, but I can't fix it unless you give me a complete test case. I don't have time to try to reverse-engineer your schem

[SQL] problem with view in 7.3

2002-12-03 Thread Alphasoft
Hi , I am Hristo Neshev From Bulgaria   In Version 7.2 this statement works :   create view v_impr_check(ead_no,ead_date, e_no,e_date,sid,number, s_order,cdt,cdt_description, original_qty,used_qty,waste_qty,rest_qty,original_used_qty)ASselect distinct md_custom_number, md_custom_date, md_n