Josh Berkus <[EMAIL PROTECTED]> writes:
> However, here goes. First is \d for the bad view, and second is \d and 2nd
> for the good view. I can't see any difference. Can you?
They look the same to me too, but I still think there must be a
difference. Would you look at their pg_rewrite rows to see if the
ev_action text is identical? (You want the rows with ev_class matching
the pg_class OIDs of the two views.)
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
