From: Nathan Angelacos <nba@fcc.net>
To: pgsql-sql@hub.org
Subject: CASE statement causes unknown node type 723
Date: Tue, 17 Aug 1999 19:36:27 -0400
Message-ID: <19990817233109.AAA29141@dorsey.fcc.net@compaq> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: nba@fcc.net, pgsql-sql@hub.org
Subject: Re: CASE statement causes unknown node type 723
In-Reply-To: <19990817233109.AAA29141@dorsey.fcc.net@compaq>
References: <19990817233109.AAA29141@dorsey.fcc.net@compaq>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox