Tom,

> > RELOADING the view fixed the error.
> 
> What do you mean by "reloading the view", exactly?

I created the same view under a new name.    The new view runs fine.  I 
suspect that if I REPLACED the view, it would be fixed, but I don't want to 
do that if we want to analyze it further.

> The cost numbers here are very small; are the tables themselves small, or
> did you reload them too?

The tables are quite small, the largest < 200 rows.   This view just links a 
bunch of reference lists.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to