| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-09-27 19:35:33 | Re: [HACKERS] BUG #1883: Renaming a schema leaves inconsistent |
| Previous Message | Tom Lane | 2005-09-27 18:29:58 | Re: [HACKERS] BUG #1883: Renaming a schema leaves inconsistent |