pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
CASE statement causes unknown node type 723 2+ messages / 2 participants [nested] [flat]
* CASE statement causes unknown node type 723 @ 1999-08-17 23:36 Nathan Angelacos <nba@fcc.net> 0 siblings, 1 reply; 2+ messages in thread From: Nathan Angelacos @ 1999-08-17 23:36 UTC (permalink / raw) To: pgsql-sql@hub.org 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] CASE statement causes unknown node type 723 @ 1999-08-18 13:43 Tom Lane <tgl@sss.pgh.pa.us> parent: Nathan Angelacos <nba@fcc.net> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 1999-08-18 13:43 UTC (permalink / raw) To: Nathan Angelacos <nba@fcc.net>; +Cc: pgsql-sql@hub.org "Nathan Angelacos" <nba@fcc.net> writes: > ERROR: get_ruledef of die: unknown node type 723 in > check_if_rte_used() > Is it a bug, or am I doing something stupid? Yeah, it's a known bug. It only shows up when you try to view the text of a rule containing a CASE expression. Will be fixed for 6.6 ... not sure if it's important enough to back-patch in 6.5.* ... regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-08-18 13:43 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-08-17 23:36 CASE statement causes unknown node type 723 Nathan Angelacos <nba@fcc.net> 1999-08-18 13:43 ` Tom Lane <tgl@sss.pgh.pa.us>
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