Tom Lane wrote:
>That's a fairly bad workaround (assuming that the function is a
> legitimate candidate to be IMMUTABLE) because it defeats potential
> optimizations.
>
> What I'd suggest you do instead is rethink your apparently widespread
> habit of whacking your view definitions around on-the-fly. This would
> never have worked at all before PG 8.3 (and as you can see we still have
> some bugs left in supporting it in 8.3 :-(). Even when it does work,
> there is a whole lot of frantic paddling going on just under the
> surface. We may sail serenely on like the swan, but not very speedily
Yep, already started reorganizing so that I don't have to hack away at
the views so much. So far I've been
able to do without the functions that would only work with volatile.
cheers,
willem
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
