Re: View's plan not taking advantage of WHERE?

From: Mike Summers <msummers57(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: View's plan not taking advantage of WHERE?
Date: 2013-06-05 11:31:52
Message-ID: CAJGeMG8_-TE7wt1ff9eiUvcsaRG2aF2-wvvjkkvwxzCP_KZE9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It appears that the culprit is a cached query plan, the tables in the UNION
have changed and no long match however the View does not throw a "each
UNION query must have the same number of columns" error.

Is there a way to force the View's query plan to be updated on each access?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2013-06-05 11:53:31 Re: View's plan not taking advantage of WHERE?
Previous Message Raymond O'Donnell 2013-06-05 11:28:20 Re: How to modify dump files created by pg_dump