Re: BUG #1913: select into a table missing a row part 2 - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #1913: select into a table missing a row part 2
Date
Msg-id 20050927192736.GG32390@surnet.cl
Whole thread Raw
In response to Re: BUG #1913: select into a table missing a row part 2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Tue, Sep 27, 2005 at 10:37:06AM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre@alvh.no-ip.org> 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."

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] BUG #1883: Renaming a schema leaves inconsistent
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] BUG #1883: Renaming a schema leaves inconsistent