Re: [BUGS] BUG #1707: statistics collector starts with stats_start_collector

2005-06-14 Thread Andreas Pflug
Bruce Momjian wrote: If we don't have a way to check this, we'll regret it soon enough... now maybe a GUC setting isn't the optimal way, but I think we need *some* way besides ps. ps doesn't work remotely and I think there's no simple equivalent under Windows either. Sure, but the GUC only

[BUGS] BUG #1718: geqo_selection.c:linear()

2005-06-14 Thread Bug Finder
The following bug has been logged online: Bug reference: 1718 Logged by: Bug Finder Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux Description:geqo_selection.c:linear() Details: In geqo_selection.c, function linear() may return a

Re: [BUGS] BUG #1712: JDBC column precision for bigint is 0

2005-06-14 Thread Kevin Grittner
I agree on all counts. The only way that I would extend the description of "the number of decimal digits" is that I think it's fairly clear that for floating point numbers it should be "the number of significant digits" since the fractional part is often only an approximation of any decimal repres

Re: [BUGS] BUG #1718: geqo_selection.c:linear()

2005-06-14 Thread Tom Lane
"Bug Finder" <[EMAIL PROTECTED]> writes: > In geqo_selection.c, function linear() may > return a value equals to pool_size, and cause > geqo_selection() to visit invalid array member. Good catch. I wonder whether roundoff error couldn't lead to trying to call sqrt() with a value slightly less th

[BUGS] pg_dump silently fails

2005-06-14 Thread Brandon Keepers
I've been wresting with this problem since 8.0.1 and am able to duplicate it on 6 different installations. If I compile postgres from source, everything works fine. If I install the RHEL 4 ES RPM, pg_dump silently fails. I've attached two straces, one from 8.0.3 RPM that fails, and one from 8.0.

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Tom Lane
Brandon Keepers <[EMAIL PROTECTED]> writes: > I've been wresting with this problem since 8.0.1 and am able to > duplicate it on 6 different installations. If I compile postgres from > source, everything works fine. If I install the RHEL 4 ES RPM, pg_dump > silently fails. Is SELinux in enforceme

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Bruce Momjian
Tom Lane wrote: > Brandon Keepers <[EMAIL PROTECTED]> writes: > > I've been wresting with this problem since 8.0.1 and am able to > > duplicate it on 6 different installations. If I compile postgres from > > source, everything works fine. If I install the RHEL 4 ES RPM, pg_dump > > silently fails

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> Is SELinux in enforcement mode, and if so does turning it off change >> things? > Should we check for a buggy SELinux and report a meaningful error > message on failure? How you intend to do that, exactly? The bug is that it won't let you write on /dev

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Brandon Keepers
On Tue, 2005-06-14 at 13:55 -0400, Tom Lane wrote: > Is SELinux in enforcement mode, and if so does turning it off change > things? Yup, that was it. If you disable SELinux, everything works. I tried just commenting out line 732 in /etc/selinux/targeted/contexts/files/file_contexts and that didn'

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> Is SELinux in enforcement mode, and if so does turning it off change > >> things? > > > Should we check for a buggy SELinux and report a meaningful error > > message on failure? > > How you intend to do that, exactly? The bug is t

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> How you intend to do that, exactly? The bug is that it won't let you >> write on /dev/tty, which puts a pretty severe crimp on *any* reporting. > Throw a message to stderr saying something about SELinux. Unless stderr is pointing somewhere else than /d

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Tom Lane
Brandon Keepers <[EMAIL PROTECTED]> writes: > Yup, that was it. If you disable SELinux, everything works. I tried > just commenting out line 732 > in /etc/selinux/targeted/contexts/files/file_contexts and that didn't > work. Anyone know how to correct this? I don't know very much about SELinux,

Re: [BUGS] pg_dump silently fails

2005-06-14 Thread Ennio-Sr
* Bruce Momjian [140605, 14:00]: > Tom Lane wrote: > > Brandon Keepers <[EMAIL PROTECTED]> writes: > > > I've been wresting with this problem since 8.0.1 and am able to > > > duplicate it on 6 different installations. If I compile postgres from > > > source, everything works fine. If I install t

[BUGS] HP-UX 11.23 ia64 7.4.8 regression diff

2005-06-14 Thread Ed L.
PostgreSQL 7.4.8 on ia64-hp-hpux11.23, compiled by GCC gcc (GCC) 3.4.2 $cat ./regression.diffs*** ./expected/float8.out   Thu Sep 25 02:58:06 2003--- ./results/float8.out    Tue Jun 14 18:55:08 2005** 249,255   SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;