pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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>
  1999-08-18 13:43 ` Re: [SQL] CASE statement causes unknown node type 723 Tom Lane <tgl@sss.pgh.pa.us>
  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-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>
  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