Re: [HACKERS] join regression failure on cygwin

2009-07-24 Thread Andrew Dunstan
Tom Lane wrote: I don't personally have a problem with just forcing use of our own erand48 on Cygwin; it's not a lot of code and it would make the behavior of that build more like the MSVC build. But it's curious that such a simple library function is seemingly broken on Cygwin ... especially

Re: [HACKERS] join regression failure on cygwin

2009-07-24 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: It appears on Googling a bit that the erand48() is buggy in that it requires the seed to have been initialized with srand48() or it will constantly return 0.0. Huh, and that sends us into an infinite loop? I'll take a look at that. Even though it's

Re: [HACKERS] join regression failure on cygwin

2009-07-24 Thread Tom Lane
I wrote: Andrew Dunstan and...@dunslane.net writes: It appears on Googling a bit that the erand48() is buggy in that it requires the seed to have been initialized with srand48() or it will constantly return 0.0. Huh, and that sends us into an infinite loop? I'll take a look at that. Even

Re: [HACKERS] join regression failure on cygwin

2009-07-24 Thread Andrew Dunstan
Tom Lane wrote: I wrote: Andrew Dunstan and...@dunslane.net writes: It appears on Googling a bit that the erand48() is buggy in that it requires the seed to have been initialized with srand48() or it will constantly return 0.0. Huh, and that sends us into an infinite

Re: [HACKERS] join regression failure on cygwin

2009-07-23 Thread Andrew Dunstan
Tom Lane wrote: I see it claims to have working erand48, but maybe not so much in reality? Good guess. I removed erand48 from the configure file and added erand48.o to OBJS in src/port/Makefile and it suddenly sailed through. cheers andrew -- Sent via

Re: [HACKERS] join regression failure on cygwin

2009-07-23 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: I see it claims to have working erand48, but maybe not so much in reality? Good guess. I removed erand48 from the configure file and added erand48.o to OBJS in src/port/Makefile and it suddenly sailed through. Hmm. So we need to

Re: [HACKERS] join regression failure on cygwin

2009-07-23 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: I see it claims to have working erand48, but maybe not so much in reality? Good guess. I removed erand48 from the configure file and added erand48.o to OBJS in src/port/Makefile and it suddenly

Re: [HACKERS] join regression failure on cygwin

2009-07-23 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: Hmm. So we need to figure out how to improve configure's check so that it rejects whatever broken version you've got ... Yeah. Any ideas? I'd hate just to exclude the system erand48 on Cygwin and then find out later it's broken on

Re: [HACKERS] join regression failure on cygwin

2009-07-23 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: Hmm. So we need to figure out how to improve configure's check so that it rejects whatever broken version you've got ... Yeah. Any ideas? I'd hate just to exclude the system erand48 on Cygwin

Re: [HACKERS] join regression failure on cygwin

2009-07-23 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: I'll work on it, but for now I propose to make the following change to configure.in and the corresponding change in configure: I believe you can just add AC_LIBOBJ(erand48) in the Cygwin-specific section without touching the other part; that's

[HACKERS] join regression failure on cygwin

2009-07-22 Thread Andrew Dunstan
My Cygwin buildfarm member started failing (hanging, in fact) recently. It seems to hang consistently in join.sql and the only way I can get it to complete is to kill the backend fairly violently. See http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=brown_batdt=2009-07-22%2023:10:21 It

Re: [HACKERS] join regression failure on cygwin

2009-07-22 Thread Andrew Dunstan
I wrote: My Cygwin buildfarm member started failing (hanging, in fact) recently. It seems to hang consistently in join.sql and the only way I can get it to complete is to kill the backend fairly violently. See

Re: [HACKERS] join regression failure on cygwin

2009-07-22 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: My Cygwin buildfarm member started failing (hanging, in fact) recently. It seems to hang consistently in join.sql and the only way I can get it to complete is to kill the backend fairly violently. See