Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0E0A3475FDD for ; Tue, 3 Dec 2002 10:19:20 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 9B700475F63 for ; Tue, 3 Dec 2002 10:19:18 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id gB3FIgpd023563; Tue, 3 Dec 2002 10:18:42 -0500 (EST) To: "Alphasoft" Cc: pgsql-sql@postgresql.org Subject: Re: problem with view in 7.3 In-reply-to: <002f01c29add$53ebafc0$0a0546c0@alpha.bg> References: <002f01c29add$53ebafc0$0a0546c0@alpha.bg> Comments: In-reply-to "Alphasoft" message dated "Tue, 03 Dec 2002 17:04:39 +0200" Date: Tue, 03 Dec 2002 10:18:42 -0500 Message-ID: <23562.1038928722@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/32 X-Sequence-Number: 10620 "Alphasoft" 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 schema... "pg_dump -s" is a quick way to make a script that just creates your tables without any data. regards, tom lane