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

2010-09-24 Thread Magnus Hagander
On Fri, Sep 24, 2010 at 00:41, Peter Eisentraut wrote: > 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 goi

Re: [BUGS] installer problems

2010-09-24 Thread Dave Page
On Fri, Sep 24, 2010 at 6:28 AM, Peter Eisentraut wrote: > 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 re

Re: [BUGS] installer problems

2010-09-24 Thread Dimitri Fontaine
Dave Page writes: > On Fri, Sep 24, 2010 at 6:28 AM, Peter Eisentraut wrote: >> On tor, 2010-09-23 at 23:56 +0100, Dave Page wrote: >>> > Surely the error message can be polished, though? > > How else would you suggest we find out what may go wrong on an > unsupported platform? My guess here is

Re: [BUGS] installer problems

2010-09-24 Thread Dave Page
On Fri, Sep 24, 2010 at 11:30 AM, Dimitri Fontaine wrote: > Dave Page writes: >> On Fri, Sep 24, 2010 at 6:28 AM, Peter Eisentraut wrote: >>> On tor, 2010-09-23 at 23:56 +0100, Dave Page wrote: > Surely the error message can be polished, though? >> >> How else would you suggest we find out

[BUGS] BUG #5675: out of memory at request size 32Mb

2010-09-24 Thread Andreas Pflug
The following bug has been logged online: Bug reference: 5675 Logged by: Andreas Pflug Email address: pgad...@pse-consulting.de PostgreSQL version: 8.4.4 Operating system: Linux 2.6.26 i686 Description:out of memory at request size 32Mb Details: A slony 2.0 cluster

Re: [BUGS] BUG #5675: out of memory at request size 32Mb

2010-09-24 Thread Robert Haas
On Fri, Sep 24, 2010 at 8:42 AM, Andreas Pflug wrote: > > The following bug has been logged online: > > Bug reference:      5675 > Logged by:          Andreas Pflug > Email address:      pgad...@pse-consulting.de > PostgreSQL version: 8.4.4 > Operating system:   Linux 2.6.26 i686 > Description:  

Re: [BUGS] installer problems

2010-09-24 Thread Robert Haas
On Thu, Sep 23, 2010 at 11:45 AM, 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  : child

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

2010-09-24 Thread David Schmitt
On 9/23/2010 9:53 PM, Tom Lane wrote: 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/pat

Re: [BUGS] BUG #5675: out of memory at request size 32Mb

2010-09-24 Thread Andreas Pflug
Am 24.09.10 14:54, schrieb Robert Haas: On Fri, Sep 24, 2010 at 8:42 AM, Andreas Pflug wrote: The following bug has been logged online: Bug reference: 5675 Logged by: Andreas Pflug Email address: pgad...@pse-consulting.de PostgreSQL version: 8.4.4 Operating system: Linux

[BUGS] Fehler beim Installieren von PostgreSQL v8.4.3-1

2010-09-24 Thread Benito Schlaak
Hallo Support, ich habe gestern ein Windows 7 x64 Professional frisch aufgesetzt. Bei der installation von PostgreSQL tritt dabei am ende der installation ein Fehler auf. Fehler: Problem running post-install step.Installation may not complete correctly. Error reading file C:/progam Files (x86

Re: [BUGS] installer problems

2010-09-24 Thread Peter Eisentraut
On fre, 2010-09-24 at 09:01 +0100, Dave Page wrote: > How else would you suggest we find out what may go wrong on an > unsupported platform? Well, some amount of robust and defensive programming can probably create better error messages in even the most unknown environment. Especially since the pr

Re: [BUGS] installer problems

2010-09-24 Thread Peter Eisentraut
On fre, 2010-09-24 at 11:38 +0100, Dave Page wrote: > I didn't know that existed - thanks. Unfortunately the first box I > tried it on didn't have it, but that's quite old and not a supported > platform anyway. if it does exist on everything we support, then that > could work. It's tempting, but I

Re: [BUGS] installer problems

2010-09-24 Thread Alvaro Herrera
Excerpts from Peter Eisentraut's message of vie sep 24 10:55:58 -0400 2010: > On fre, 2010-09-24 at 11:38 +0100, Dave Page wrote: > > I didn't know that existed - thanks. Unfortunately the first box I > > tried it on didn't have it, but that's quite old and not a supported > > platform anyway. if i

Re: [BUGS] installer problems

2010-09-24 Thread Dave Page
On Fri, Sep 24, 2010 at 3:52 PM, Peter Eisentraut wrote: > On fre, 2010-09-24 at 09:01 +0100, Dave Page wrote: >> How else would you suggest we find out what may go wrong on an >> unsupported platform? > > Well, some amount of robust and defensive programming can probably > create better error mes

Re: [BUGS] installer problems

2010-09-24 Thread Dave Page
On Fri, Sep 24, 2010 at 4:09 PM, Alvaro Herrera wrote: > Excerpts from Peter Eisentraut's message of vie sep 24 10:55:58 -0400 2010: >> On fre, 2010-09-24 at 11:38 +0100, Dave Page wrote: >> > I didn't know that existed - thanks. Unfortunately the first box I >> > tried it on didn't have it, but t

Re: [BUGS] BUG #5595: Documentation is not installs from VPATH build.

2010-09-24 Thread Alvaro Herrera
Excerpts from Alvaro Herrera's message of jue ago 26 17:01:14 -0400 2010: > Excerpts from Alvaro Herrera's message of jue ago 26 16:46:42 -0400 2010: > > Excerpts from Tom Lane's message of jue ago 26 16:38:07 -0400 2010: > > > Those wildcards look a bit scary, although I suppose only a really > >

Re: [BUGS] Fehler beim Installieren von PostgreSQL v8.4.3-1

2010-09-24 Thread Craig Ringer
On 24/09/2010 8:51 PM, Benito Schlaak wrote: Hallo Support, ich habe gestern ein Windows 7 x64 Professional frisch aufgesetzt. Bei der installation von PostgreSQL tritt dabei am ende der installation ein Fehler auf. Fehler: Problem running post-install step.Installation may not complete correctl

Re: [BUGS] Fehler beim Installieren von PostgreSQL v8.4.3-1

2010-09-24 Thread Dave Page
On Fri, Sep 24, 2010 at 4:18 PM, Craig Ringer wrote: > On 24/09/2010 8:51 PM, Benito Schlaak wrote: >> >> Hallo Support, >> >> ich habe gestern ein Windows 7 x64 Professional frisch aufgesetzt. Bei >> der installation von PostgreSQL tritt dabei am ende der installation ein >> Fehler auf. >> Fehler

[BUGS] BUG #5676: When creating a trigger an dummy argument is inserted.

2010-09-24 Thread Christopher Hotchkiss
The following bug has been logged online: Bug reference: 5676 Logged by: Christopher Hotchkiss Email address: christopher.a.hotchk...@jpmchase.com PostgreSQL version: 9.0.0 Operating system: Ubuntu 10.04 x64 Description:When creating a trigger an dummy argument is ins

Re: [BUGS] BUG #5676: When creating a trigger an dummy argument is inserted.

2010-09-24 Thread Tom Lane
"Christopher Hotchkiss" writes: > When creating the following trigger: > CREATE TRIGGER c_aud_trg > BEFORE INSERT OR UPDATE OR DELETE > ON ca > FOR EACH ROW > EXECUTE PROCEDURE c_aud_trg_trfunc(); > It will actually get created as (using pgAdmin 1.12): > CREATE TRIGGER c_aud_trg > BEFO

Re: [BUGS] installer problems

2010-09-24 Thread Peter Eisentraut
On fre, 2010-09-24 at 16:10 +0100, Dave Page wrote: > The download page states exactly what distros we consider supported. Sorry, I was actually looking at the Postgres Plus download page. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5676: When creating a trigger an dummy argument is inserted.

2010-09-24 Thread Christopher A Hotchkiss
Thanks Tom, I will report it to them. Christopher A Hotchkiss JPMorgan Chase & Co. - Navy Cash Application Developer Email christopher.a.hotchk...@jpmchase.com -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, September 24, 2010 12:04 PM To: Christopher A Hotchk

[BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-24 Thread stagirus
Good afternoon. I am the Chief Architect, with 19 years of experience in the software industry, for an enterprise software product. I am requesting your help to better understand or resolve the following issue. Our architecture is based on Spring and Hibernate. The product is required to support

Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-24 Thread Kevin Grittner
stagirus wrote: > JDBC driver does not convert boolean value (false/true) to > integers (0/1). Can you mention which methods of which classes you would expect to do this? -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www

Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-24 Thread stagirus
Thank you for your quick response. As I stated above, we directly do not call any JDBC API, not any more. It is all done by Hibernate OR mapping. The above solution (Hibernate mapping) worked fine with Oracle JDBC drivers, for a long time. I believe Hibernate might be mapping, or calling the appro

Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-24 Thread Kevin Grittner
[Moving the discussion to the PostgreSQL JDBC list, with a blind copy to bugs. This doesn't sound to me like a bug, per se, but an extension to the JDBC driver which may be a convenience to some users. We're more likely to get the attention of the right group of people on the JDBC list.] stagir

[BUGS] BUG #5677: missing libuuid.so.16 library

2010-09-24 Thread Andrew Geery
The following bug has been logged online: Bug reference: 5677 Logged by: Andrew Geery Email address: andrew.ge...@gmail.com PostgreSQL version: 9.0 Operating system: Ubuntu 10.10 Description:missing libuuid.so.16 library Details: In 8.4, the one-click installer for

Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-24 Thread Craig Ringer
On 09/25/2010 05:33 AM, stagirus wrote: > Good afternoon. I am the Chief Architect, with 19 years of experience > in the software industry Without meaning to sound excessively grumpy, I'm surprised that those 19 years didn't teach you to provide detailed error messages, in-depth description, a

Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)

2010-09-24 Thread Dean Rasheed
>> Now comes the "religious" discussion. The above design works well for >> Oracle, DB2 and MySQL, etc. But PostgresQL seems to choke. It complains >> about the data type mismatch. By reading various discussions on your >> forum, >> there seems to some issues with the data type mapping at the JDBC