I am trying to update a view, and I get the following error:

ERROR: expression_tree_walker: Unexpected node type 711

Version: PostgreSQL 7.3.2

The view is to replace an old view, but I get the same view
if I rename it and create a new view. The relevant portions
of the view that changed are listed below:

------------OLD VERSION---------------------
CREATE OR REPLACE VIEW XXXXXXXX
....
CASE WHEN sv.is_bit_field THEN sv.length
ELSE cdt.bit_length * COALESCE(sv.length, 1)
END AS bit_length,
....
--------END OLD VERSION---------------------

------------NEW VERSION---------------------
CREATE OR REPLACE VIEW XXXXXXXX
....
CASE WHEN sv.is_bit_field THEN COALESCE(sv.length, const.num_value, ev.value, evconst.num_value)
ELSE cdt.bit_length * COALESCE(sv.length, const.num_value, ev.value, evconst,num_value, 1)
END AS bit_length,
....
OUTER JOIN t_Constants const ON sv.fk_t_Constants = const.pk_t_Constants
OUTER JOIN t_Enum_Vars ev ON sv.fk_t_Enum_Vars = ev.pk_t_Enum_Vars
OUTER JOIN t_Constants evconst ON ev.fk_t_Constants = evconst.pk_t_Constants
--------END NEW VERSION---------------------

Any help on what went wrong? As far as I can tell, I'm not
doing anything here I haven't in a hundred other places.

--David


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

David Morris <lists (AT) morris-clan (DOT) net> writes:
Could we see a *complete* example that reproduces the problem?
It's difficult to speculate with partial evidence.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match