[BUGS] Postgresql installation on P2020 board

2010-09-23 Thread TamilSelvam M
Hi, im trying to install postgresql8.4 in P2020 board . when i try to start postgresql im facing the follwing error. [postg...@p2020ds /]$ initdb -D /usr/local/data/ The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The data

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-23 Thread Robert Haas
On Wed, Sep 22, 2010 at 9:04 PM, Tom Lane wrote: > Robert Haas writes: >> Can SHOW return a NULL value, rather than the empty string? > > I think that would take some work in guc.c, and likely a redefinition > of the API for show-hook functions.  I'm not excited about doing it, > particularly not

Re: [BUGS] Postgresql installation on P2020 board

2010-09-23 Thread Tom Lane
TamilSelvam M writes: > im trying to install postgresql8.4 in P2020 board . > when i try to start postgresql im facing the follwing error. > creating template1 database in /usr/local/data/base/1 ... FATAL: only sys > attr supported in caches is OID Offhand I'd guess you have a compiler bug to

[BUGS] installer problems

2010-09-23 Thread Samuel Rettore
Hi, I'm having problems installing the database, see: anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin Error: Error running /tmp/postgresql_installer/getlocales : child killed: floating-point exception Press [Enter] to continue : anfitrite:/opt# anfitrite:/opt# uname -a Linux anfitrite 2.6.18-6

[BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread David Schmitt
The following bug has been logged online: Bug reference: 5673 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8.4.4 Operating system: Windows 7 Description:Optimizer creates strange execution plan leading to wrong results Details: Backgroun

Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread Tom Lane
"David Schmitt" writes: > Description:Optimizer creates strange execution plan leading to > wrong results Please supply a self-contained example demonstrating the incorrect results. The information you've provided is completely inadequate for investigating this problem report. A SQL scri

Re: [BUGS] installer problems

2010-09-23 Thread Dave Page
On Thu, Sep 23, 2010 at 3:19 PM, Samuel Rettore wrote: > Hi, > > I'm having problems installing the database, see: > > anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin > > Error: Error running /tmp/postgresql_installer/getlocales  : child killed: > floating-point exception > Press [Enter] to continu

Re: [BUGS] Postgresql installation on P2020 board

2010-09-23 Thread Alvaro Herrera
Excerpts from TamilSelvam M's message of jue sep 23 02:08:05 -0400 2010: > creating template1 database in /usr/local/data/base/1 ... FATAL: only sys > attr supported in caches is OID > PANIC: cannot abort transaction 1, it was already committed > child process was terminated by signal 6: Aborte

Re: [BUGS] libpq: system-wide root.crt

2010-09-23 Thread Tom Lane
Magnus Hagander writes: > On Thu, Aug 19, 2010 at 23:11, Martin Pitt wrote: >>> I received a request to support system-wide root certificates in >>> libpq. > I wonder if we want to have a default value for this rather than > disabling it when it's not specified by configure. But is there any > k

Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread David Schmitt
On 9/23/2010 5:33 PM, Tom Lane wrote: "David Schmitt" writes: Description:Optimizer creates strange execution plan leading to wrong results Please supply a self-contained example demonstrating the incorrect results. The information you've provided is completely inadequate for investig

Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread Tom Lane
David Schmitt writes: > On 9/23/2010 5:33 PM, Tom Lane wrote: >> Please supply a self-contained example demonstrating the incorrect results. > Executing the attached example.sql on a fresh database demonstrates the > problem I'm seeing: Yup, it sure does. Looking for the cause now. Thanks for

[BUGS] Feature request - pg_dump - -W specify pwd in command line

2010-09-23 Thread Carl Holliday
Afternoon the 8.4 pg_dump seems to work fine and as documented. I need to be able to put pwds in the command line to facilitate non-supervised backups etc I tried the following command line but, understandably, it refuses to cooperate: pg_dump.exe -h localhost -p 5432 -U postgres -W tstpwd1 -t

Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread Tom Lane
David Schmitt writes: > Executing the attached example.sql on a fresh database demonstrates the > problem I'm seeing: Found it. If you need a patch right away, it's a one-liner: diff --git a/src/backend/optimizer/path/allpaths.c b/src/backend/optimizer/path/allpaths.c index 2d86da3..b7cf0b8 1

Re: [BUGS] Feature request - pg_dump - -W specify pwd in command line

2010-09-23 Thread Tom Lane
"Carl Holliday" writes: > I need to be able to put pwds in the command line to facilitate > non-supervised backups etc We intentionally do not allow passwords on the command line, because putting them there is a huge security hole. Use a ~/.pgpass file instead. See http://www.postgresql.org/doc

Re: [BUGS] UNLISTEN bug

2010-09-23 Thread Tom Lane
Jeff Davis writes: > The bug is pretty simple: ProcessIncomingNotify() is called in a tight > loop in EnableNotifyInterrupt() while notifyInterruptOccurred is true. > EnableNotifyInterrupt() is assuming that ProcessIncomingNotify() will > unset it, but it has an early return that's triggered by my

Re: [BUGS] libpq: system-wide root.crt

2010-09-23 Thread Peter Eisentraut
On tor, 2010-09-23 at 08:36 +0200, Magnus Hagander wrote: > I wonder if we want to have a default value for this rather than > disabling it when it's not specified by configure. But is there any > kind of reasonable default that's not going to be > platform/distribution specific? I would like for

Re: [BUGS] installer problems

2010-09-23 Thread Peter Eisentraut
On tor, 2010-09-23 at 16:45 +0100, Dave Page wrote: > On Thu, Sep 23, 2010 at 3:19 PM, Samuel Rettore wrote: > > Hi, > > > > I'm having problems installing the database, see: > > > > anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin > > > > Error: Error running /tmp/postgresql_installer/getlocales :

Re: [BUGS] installer problems

2010-09-23 Thread Dave Page
On Thu, Sep 23, 2010 at 11:46 PM, Peter Eisentraut wrote: > On tor, 2010-09-23 at 16:45 +0100, Dave Page wrote: >> On Thu, Sep 23, 2010 at 3:19 PM, Samuel Rettore wrote: >> > Hi, >> > >> > I'm having problems installing the database, see: >> > >> > anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin >

Re: [BUGS] installer problems

2010-09-23 Thread Peter Eisentraut
On tor, 2010-09-23 at 23:56 +0100, Dave Page wrote: > > Surely the error message can be polished, though? > > Well we don't know what errors we might get on unsupported platforms > until we test them, and we certainly don't have the resources to test > every unsupported platform. It's hard enough

[BUGS] BUG #5674: initdb failed if path contains symlink

2010-09-23 Thread Itagaki Takahiro
The following bug has been logged online: Bug reference: 5674 Logged by: Itagaki Takahiro Email address: itagaki.takah...@gmail.com PostgreSQL version: 9.0.0 (32bit) Operating system: Windows 7 (64bit) Description:initdb failed if path contains symlink Details: Wind