Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> I cannot think of any commit that fixed that??? Is it fixed in 7.3.5?
7.3.5 exhibits the same misbehavior. The bug is actually that the index
doesn't get dropped when you drop the column, and it was fixed here:
2003-05-28 12:03 tgl
Replace functional-index facility with expressional indexes.
...
Along the way, ... fix 7.3 oversight
that didn't record dependencies of predicate expressions.
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
