Received: from dorsey.fcc.net (dorsey.fcc.net [207.198.253.29]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA29157 for ; Tue, 17 Aug 1999 19:31:44 -0400 (EDT) (envelope-from nba@fcc.net) Received: from compaq ([207.198.222.61]) by dorsey.fcc.net (Post.Office MTA v3.5.2 release 221 ID# 0-57968U12500L1250S0V35) with SMTP id net for ; Tue, 17 Aug 1999 19:31:09 -0400 From: "Nathan Angelacos" To: pgsql-sql@hub.org Date: Tue, 17 Aug 1999 19:36:27 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: CASE statement causes unknown node type 723 Priority: normal X-mailer: Pegasus Mail for Win32 (v3.11) Message-ID: <19990817233109.AAA29141@dorsey.fcc.net@compaq> On a [PostgreSQL 6.5.1 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66] (Redhat) system, I get an unknown node type 723 error when trying to do a pg_dump on a db, or specifically, trying to select from pg_views after creating a view with a CASE statement. To duplicate: in any database (e.g. template1) =>select * from pg_views (Returns the expected results) => create view die as => select => CASE when usename = 'postgres' then 'something' => ELSE usename => End => from pg_user; (Creates view 'die') =>select * from die (Works fine, but now....) =>select * from pg_views root=> select * from pg_views; ERROR: get_ruledef of die: unknown node type 723 in check_if_rte_used() Is it a bug, or am I doing something stupid? Thanks.