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])