"Peter Brant" <[EMAIL PROTECTED]> writes:
The same problem exists in 8.1 too. See this thread
http://archives.postgresql.org/pgsql-bugs/2006-04/msg00177.php
Tom and Magnus tracked down a cause, but I don't think a fix was ever
implemented.
Thomas seems to have two different issues there: the "
Hi,
I have a query that throws "ERROR: failed to build any 4-way joins
SQL state: XX000".
Here's an (arguably) simplified version of it that doesn't require any of my
table:
select
1
from
(select 1 as col) t1
cross join (select 1 as col) t2
left outer join (select 1 as col) t3
on
another lockup, this time due to pgstat_write_statsfile :-(
2006-10-24 17:01:17 [5412] LOG: XX000: could not rename temporary
statistics file "global/pgstat.tmp" to "global/pgstat.stat": A blocking
operation was interrupted by a call to WSACancelBlockingCall.
2006-10-24 17:01:17 [5412] LOCATI
The following bug has been logged online:
Bug reference: 2717
Logged by: Pavel
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Linux Redhat
Description:performance problem with enable_bitmapscan
Details:
Hi,
i have a following performan
"JEAN-PIERRE PELLETIER" <[EMAIL PROTECTED]> writes:
> I have a query that throws "ERROR: failed to build any 4-way joins
Fixed --- thanks for the report! (This didn't make beta2, but will
be in the next one.)
regards, tom lane
---(end of broadcast
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >>> Actually, the 8.0.X libpq function would still report 70401 if connected
> >>> to a 7.4.1 database,
> >>
> >> That was exactly the reason why the docs were written l
I have made a clearer example of the bug I reported to -hackers
yesterday:
http://archives.postgresql.org/pgsql-hackers/2006-10/msg01252.php
The following example shows a simple case that fails on 8.0+ (including
CVS HEAD), but works fine on 7.4. There are two almost identical
situations, and one
How about this patch?
Of course, it might be a rare case that such check is necessary...
Toru SHIMOGAKI wrote:
> The following bug has been logged online:
>
> Bug reference: 2704
> Logged by: Toru SHIMOGAKI
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.1.4
> Ope
