Shawn Harrison wrote [01/28/05 3:53 PM]:
create or replace rule objects__update as on update to objects
do instead (
update objects_data set
name = new.name,
typename = new.typename,
parent = new.parent,
^^^^This is a simplified version of the rule; the real one didn't have this syntax error.
where id = new.id ); ...
-- ________________ [EMAIL PROTECTED]
---------------------------(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
