On Tue, Sep 27, 2005 at 10:37:06AM -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > It may be related to the latest outer join bug, which Tom Lane fixed > > yesterday or the day before. I'll recompile and retest. > > That was my first thought also. Does the plan for the select-from-view > involve a hash join? Have you finished testing with CVS tip yet?
Yes, it does involve hash joins, and yes I did test CVS tip, and the problem doesn't happen there; or at least I can't reproduce it. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34 "Everybody understands Mickey Mouse. Few understand Hermann Hesse. Hardly anybody understands Einstein. And nobody understands Emperor Norton." ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
