Josh Berkus <[EMAIL PROTECTED]> writes: >> What do you mean by "reloading the view", exactly?
> I created the same view under a new name. The new view runs fine. [scratches head...] That doesn't make any sense to me at all ... there must be some difference between the two view definitions. The planner doesn't have any statistics associated with views, only with underlying tables (in fact it never even sees the views). Please compare \d output for the two views. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly