Skip site navigation (1) Skip section navigation (2)

Re: BUG #1913: select into a table missing a row part 2

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Keith Randall <randallk(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1913: select into a table missing a row part 2
Date: 2005-09-27 19:27:36
Message-ID: 20050927192736.GG32390@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Sep 27, 2005 at 10:37:06AM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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."

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-09-27 19:35:33
Subject: Re: [HACKERS] BUG #1883: Renaming a schema leaves inconsistent
Previous:From: Tom LaneDate: 2005-09-27 18:29:58
Subject: Re: [HACKERS] BUG #1883: Renaming a schema leaves inconsistent

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group