Re: [BUGS] Planner problems in 8.2.4 and 8.2.5 (was: Possible planner bug/regression introduced in 8.2.5)

I wrote: >> This might be a bug in the LIKE estimator (if so, it's in 8.2.3 as >> well). I don't have time to look closer right now, but can you show us >> the pg_stats row for orders_smaller.order_number? > Oh, never mind that ... on inspection, the NOT LIKE selectivity > estimator is obviously

Re: [BUGS] Test suite fails on alpha architecture

Pedro Gimeno <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> BTW, having now looked closely at the diffs, the problems do not seem >> be anywhere near the code we changed for 8.3. So I think the real >> issue is that your compiler and glibc changed under you. Could you >> perhaps retest 8

Re: [BUGS] Test suite fails on alpha architecture

Tom Lane wrote: BTW, having now looked closely at the diffs, the problems do not seem be anywhere near the code we changed for 8.3. So I think the real issue is that your compiler and glibc changed under you. Could you perhaps retest 8.2 with the current toolchain and confirm that it

[BUGS] BUG #3728: pthread autoconf hangs

The following bug has been logged online: Bug reference: 3728 Logged by: heasley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.10 Operating system: sparc-sun-solaris2.9 gcc-4.1.1 Description:pthread autoconf hangs Details: If the autoconf script ends-up w

Re: [BUGS] Test suite fails on alpha architecture

On Wed, Nov 07, 2007 at 01:49:53PM -0500, Tom Lane wrote: > Steve Langasek <[EMAIL PROTECTED]> writes: > > It may be specific to particular versions of glibc and the kernel. At least > > one of the test regressions is actually due to the bug described in > >

Re: [BUGS] Test suite fails on alpha architecture

Falk Hueffner <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> It looks to me like Debian's compiler must be allowing the division >> instruction to be speculatively executed before the if-test branch >> is taken. > Can you create a stand-alone testcase for this? I don't have

Re: [BUGS] Test suite fails on alpha architecture

Tom Lane <[EMAIL PROTECTED]> writes: > All the other diffs that Martin showed are divide-by-zero failures, > and I do not see any of them on Gentoo's machine. I think that this > must be a compiler bug. The first example in his diffs is just > "select 1/0", which executes this code: > > int3

Re: [BUGS] pg_get_indexdef excludes tablespace info

"Steven Flatt" <[EMAIL PROTECTED]> writes: > Would this be considered a bug or is the tablespace info excluded for > a particular reason? It's intentional: pg_dump doesn't want it there. In a pg_dump script we want to do set default_tablespace = foo_space; create index foo_idx o

Re: [BUGS] Test suite fails on alpha architecture

Hi Tom, Tom Lane [2007-11-07 13:49 -0500]: > Bottom line is that I see nothing here that the Postgres project can > fix --- these are library and compiler bugs. Thank you for your detailled analysis! I'll file bugs to the appropriate places then. Thanks, Martin -- Martin Pitt http://w

[BUGS] pg_get_indexdef excludes tablespace info

Postgres 8.2.4. Would this be considered a bug or is the tablespace info excluded for a particular reason? # CREATE TABLESPACE foo_space LOCATION '/some/dir'; # CREATE TABLE foo (a int); # CREATE INDEX foo_idx ON foo(a) TABLESPACE foo_space; # SELECT pg_get_indexdef(oid) FROM pg_class WHERE reln

Re: [BUGS] Test suite fails on alpha architecture

Martin Pitt <[EMAIL PROTECTED]> writes: > The testsuite of 8.3 beta 2 fails on the Alpha architecture (versions > up to 8.2 worked fine). Apparently there is some disagreement about > how to report divisions by zero: BTW, having now looked closely at the diffs, the problems do not seem to be anywh

Re: [BUGS] Test suite fails on alpha architecture

Steve Langasek <[EMAIL PROTECTED]> writes: > It may be specific to particular versions of glibc and the kernel. At least > one of the test regressions is actually due to the bug described in > ; I haven't dug > into the rest of the failur

[BUGS] wrong results at using ltree

I think I found a bug in the ltree module. The following query should return false but I get true. SELECT '5.0.1.0'::ltree ~ '5.!0.!0.0'::lquery I get the same result with the 'ltree.dll' of PostgreSQL 8.2.5. If you have a solution of the problem I would be very happy. -

Re: [BUGS] BUG #3727: error in registering the downloaded postgresql(v 7.0 and later) driver

mayuri wrote: I have register the postgreSQL (V 7.0 and later) driver in netbeans5.5.The driver supports but add the coding level while registering driver it give me error that org.postgresql.driver is not exist. Class names are case-sensitive. It should be "org.postgresql.Driver", note the ca

[BUGS] BUG #3727: error in registering the downloaded postgresql(v 7.0 and later) driver

The following bug has been logged online: Bug reference: 3727 Logged by: mayuri Email address: [EMAIL PROTECTED] PostgreSQL version: postgreSQL 8.2 Operating system: windowsXP Description:error in registering the downloaded postgresql(v 7.0 and later) driver Details:

[BUGS] BUG #3726: Unable to upgrade

The following bug has been logged online: Bug reference: 3726 Logged by: Derek G Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: WinXP Description:Unable to upgrade Details: Since installing v8.2.1 I have been unable to upgrade to later