"Donald Fraser" writes:
> I found the solution to the problem and it would therefore appear as though
> this is not a bug!
> If I change the function definition to be "STABLE" instead of "VOLATILE",
> then the problem goes away.
Yeah, that's intentional. If the planner flattens a view that has
On Wed, Mar 23, 2011 at 8:10 AM, Donald Fraser wrote:
> - Original Message -
>
> Sent: Wednesday, March 23, 2011 12:50 PM
> Subject: Index Ignored Due To Use Of View
> PostgreSQL 8.3.14
> OS: Linux Redhat 5.4
>
> Note: I have used the same subject for this email taken from an email:
> Post
- Original Message -
Sent: Wednesday, March 23, 2011 12:50 PM
Subject: Index Ignored Due To Use Of View
PostgreSQL 8.3.14
OS: Linux Redhat 5.4
Note: I have used the same subject for this email taken from an email: Posted
2011-02-24 13:29:22-08 by "David Johnston", because thi
PostgreSQL 8.3.14
OS: Linux Redhat 5.4
Note: I have used the same subject for this email taken from an email: Posted
2011-02-24 13:29:22-08 by "David Johnston", because this seems to be a very
similar observation.
Bug/Problem Summary:
We are using a simple query based on a simple view and the q
