Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA59117 for ; Thu, 5 Aug 1999 12:09:09 -0400 (EDT) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Thu, 5 Aug 1999 11:09:08 -0500 (CDT) Date: Thu, 5 Aug 1999 11:09:08 -0500 From: "Ross J. Reedstrom" To: Tom Lane Cc: rob caSSon , pgsql-sql@postgresql.org Subject: Re: [SQL] primary key view failure Message-ID: <19990805110908.C7495@wallace.ece.rice.edu> References: <4102.933863176@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: <4102.933863176@sss.pgh.pa.us>; from Tom Lane on Thu, Aug 05, 1999 at 10:26:16AM -0400 On Thu, Aug 05, 1999 at 10:26:16AM -0400, Tom Lane wrote: > rob caSSon writes: > > i have a perfectly valid sql statement that returns expected results, but > > when i create a view based on the same sql, i get 0. > > Your example seems to work fine for me with current sources. > What version are you running? > > regards, tom lane I just got the same results as Rob, with a 6.5.0 install, and a hopefully helpful error message: idas_proto=> SELECT * FROM blah; relname|attname -------+------- (0 rows) idas_proto=> \d blah ERROR: get_ruledef of blah: unknown node type 111 in check_if_rte_used() idas_proto=> select version(); version -------------------------------------------------------------- PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3 (1 row) idas_proto=> So, is this fixed in 6.5.1, or is it something that needs backporting from current? Ross P.S. Rob, good show, using an example pulling from the system tables: makes it really easy for others to test. -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005