[BUGS] BUG #4984: One click Installation error.

2009-08-12 Thread Carlos B Netto
The following bug has been logged online: Bug reference: 4984 Logged by: Carlos B Netto Email address: cobbne...@hotmail.com PostgreSQL version: 8.4.0-1 Operating system: Windows Server 2003 Description:One click Installation error. Details: Error during installatio

Re: [BUGS] BUG #4982: Wrong result of cartesian product when function result included in where clause

2009-08-12 Thread Tom Lane
"hwa" writes: > -- Cartesian product of all rows from table konten without konto_id = 4. I > expect 9 rows from this query. > SELECT abschlussart, abschlussdatum, konto_id, kontoname FROM public.konten, > public.abschlusstermine > WHERE konto_id in (select * from public.get_konten()); I get 9 row

Re: [BUGS] BUG #4983: PostgreSQL build fails

2009-08-12 Thread Alvaro Herrera
Raja Rayaprol wrote: > The build fails with the following error > gmake[3]: *** No rule to make target `utf8_and_shift_jis_2004.o', needed by > `utf8_and_shift_jis_2004.so'. Stop. > ~ > When I checked, I did not find the utf8_and_shift_jis_2004.c file in the > parent directory You need to uncomp

[BUGS] BUG #4983: PostgreSQL build fails

2009-08-12 Thread Raja Rayaprol
The following bug has been logged online: Bug reference: 4983 Logged by: Raja Rayaprol Email address: raja.rayap...@swift.com PostgreSQL version: 8.4 Operating system: HP-UX Description:PostgreSQL build fails Details: The build fails with the following error gmake[3

[BUGS] BUG #4982: Wrong result of cartesian product when function result included in where clause

2009-08-12 Thread hwa
The following bug has been logged online: Bug reference: 4982 Logged by: hwa Email address: helmut.r.wag...@googlemail.com PostgreSQL version: 8.4.0, 64 Bit Operating system: Mac OS X 10.5.8 Description:Wrong result of cartesian product when function result included i

Re: [BUGS] BUG #4961: pg_standby.exe crashes with no args

2009-08-12 Thread Magnus Hagander
On Wed, Aug 12, 2009 at 19:08, Fujii Masao wrote: > Hi, > > On Tue, Aug 11, 2009 at 3:10 AM, Magnus Hagander wrote: >> I have reproduced this. The problem is: >>        (void) signal(SIGUSR1, sighandler); >>        (void) signal(SIGINT, sighandler);      /* deprecated, use SIGUSR1 */ >> >> >> None

Re: [BUGS] BUG #4961: pg_standby.exe crashes with no args

2009-08-12 Thread Fujii Masao
Hi, On Tue, Aug 11, 2009 at 3:10 AM, Magnus Hagander wrote: > I have reproduced this. The problem is: >        (void) signal(SIGUSR1, sighandler); >        (void) signal(SIGINT, sighandler);      /* deprecated, use SIGUSR1 */ > > > None of these signals exist on WIN32. I think the only reason it >

Re: [BUGS] BUG #4978: "too many private dirs demanded" error during postgres startup

2009-08-12 Thread Alvaro Herrera
Jinson Abraham escribió: > I am trying to start postgres 8.3.7 service on RHEL 5.3 but am seeing the > following error in the pgstartup.log file under /var/lib/pgsql > > FATAL: too many private dirs demanded Huh, this sounds like operating system misconfiguration. How many files can a process

[BUGS] BUG #4981: Dblink issue

2009-08-12 Thread Gaurav K Srivastava
The following bug has been logged online: Bug reference: 4981 Logged by: Gaurav K Srivastava Email address: gaurav...@gmail.com PostgreSQL version: 8.3.3 Operating system: Windows xp Description:Dblink issue Details: I have created a user by command 1: create

Re: [BUGS] BUG #4977: post installation failed

2009-08-12 Thread Alvaro Herrera
Sridhar escribió: > I am trying to install Postgress DB server on RHEL 5.3 (64 bit OS , HP > system AMD 64 processor). After installation its giving a message "post > installation failed". and no more information. Did you try the RPMs instead of the one-click installer? -- Alvaro Herrera

[BUGS] BUG #4980: Dblink issue

2009-08-12 Thread Gaurav K Srivastava
The following bug has been logged online: Bug reference: 4980 Logged by: Gaurav K Srivastava Email address: gaurav...@gmail.com PostgreSQL version: 8.3 Operating system: Windows xp Description:Dblink issue Details: I have created a user by command 1: create u

[BUGS] Re: BUG #4974: Equivalent of "= ANY" and "BETWEEN" not observed by planner.

2009-08-12 Thread Greg Stark
On Wed, Aug 12, 2009 at 3:15 AM, Tom Lane wrote: > "Ian Turner" writes: >> The following queries are equivalent, because there are no integers between >> 5 and 6 and because the BETWEEN operator contemplates a closed range. >> SELECT * FROM example WHERE pk IN (5,6); >> SELECT * FROM example WHERE

Re: [BUGS] BUG #4977: post installation failed

2009-08-12 Thread Ashesh Vashi
hi Sridhar, You can find the log file @ /tmp/install-postgresql.log. That will help us to know the exact problem. Sridhar wrote: The following bug has been logged online: Bug reference: 4977 Logged by: Sridhar Email address: sree.rat...@gmail.com PostgreSQL version: 8.3.7-1

[BUGS] BUG #4978: "too many private dirs demanded" error during postgres startup

2009-08-12 Thread Jinson Abraham
The following bug has been logged online: Bug reference: 4978 Logged by: Jinson Abraham Email address: abraham.jin...@gmail.com PostgreSQL version: 8.3.7 Operating system: Linux (RHEL 5.3) Description:"too many private dirs demanded" error during postgres startup Deta

[BUGS] BUG #4977: post installation failed

2009-08-12 Thread Sridhar
The following bug has been logged online: Bug reference: 4977 Logged by: Sridhar Email address: sree.rat...@gmail.com PostgreSQL version: 8.3.7-1 Operating system: RHEL 5.3 Description:post installation failed Details: I am trying to install Postgress DB server on R

[BUGS] BUG #4975: Not properly installed during the installation comes out an alert

2009-08-12 Thread Hans
The following bug has been logged online: Bug reference: 4975 Logged by: Hans Email address: nanjangmu...@naver.com PostgreSQL version: 8.4.0 Operating system: Windows Server 2003 Standard Edition KN Service Pack 2 Description:Not properly installed during the install

Re: [HACKERS] [BUGS] BUG #4961: pg_standby.exe crashes with no args

2009-08-12 Thread Magnus Hagander
Yeah, the patch I think breaks things isn't included in 8.3.7 - it will be in 8.3.8 though... //Magnus On Wed, Aug 12, 2009 at 11:08, wader2 wrote: > I can't compile nor read source, but can tell you that > pg_standby.exe in 8.3.7 works fine. > > Magnus Hagander wrote: >> >> On Mon, Aug 10, 2009

Re: [HACKERS] [BUGS] BUG #4961: pg_standby.exe crashes with no args

2009-08-12 Thread wader2
I can't compile nor read source, but can tell you that pg_standby.exe in 8.3.7 works fine. Magnus Hagander wrote: On Mon, Aug 10, 2009 at 20:44, Tom Lane wrote: Magnus Hagander writes: If I just move those two lines into the #ifndef WIN32 block just around it, it compiles and doesn't crash on

[BUGS] BUG #4976: pgadmin - reconnect to drop database

2009-08-12 Thread Jim Michaels
The following bug has been logged online: Bug reference: 4976 Logged by: Jim Michaels Email address: jmich...@yahoo.com PostgreSQL version: 8.4.0 Operating system: Windows XP Pro SP3 Description:pgadmin - reconnect to drop database Details: 1. after some database ac