Re: [HACKERS] [COMMITTERS] pgsql: Work around reported problem that AIX's getaddrinfo() doesn't

2006-10-19 Thread Rocco Altier
This change has broken my AIX 5.2 buildfarm machine (asp/kookaburra), but doesn't seem to break the 5.3 member (grebe). It appears to have problems with stats being off now? What can I do to help debug the situation? -rocco -Original Message- From: [EMAIL PROTECTED]

Re: [HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-06 Thread Rocco Altier
Didn't the stats communication process get redone for 8.2? Or atleast some time-out related stuff. Since the problem seems to be related to stats_row_level being on, I wonder if the problem might be in that sub-system. I am guessing that vacuum is pushing some more stats through, which might

[HACKERS] Buildfarm cvsignore files

2006-09-27 Thread Rocco Altier
I noticed that the build farm is only looking for the cvs-ignore'd files for a vpath build. Attached is a patch that will stop at the CVS stage if there are any cvs-ignore'd files in the clean repository. Its not triggered by a from-source build, only what should have been a clean check out.

Re: [HACKERS] 8.2 beta blockers

2006-09-18 Thread Rocco Altier
-Original Message- From: [EMAIL PROTECTED] Yeah, I know, which is why I don't find it absolutely critical that this make it to beta1. But one of the concerns mentioned in the thread is that the changes might break things for older AIX versions. If we get it into beta1, we have a

Re: [PATCHES] [HACKERS] Linking on AIX (Was: Fix linking of OpenLDAP libraries )

2006-09-15 Thread Rocco Altier
I suspect that up to now the buildfarm had a static build of PostgreSQL. What is the output of 'ldd initdb' when it builds and runs correctly? Is libpq.so in a non-standard directory? If yes, one either has to export LIBPATH in the environment or link with -L/location/of/libpq for the

Re: [PATCHES] [HACKERS] Linking on AIX (Was: Fix linking of OpenLDAP libraries )

2006-09-15 Thread Rocco Altier
From: Tom Lane [mailto:[EMAIL PROTECTED] Albe Laurenz [EMAIL PROTECTED] writes: Up to now you have built against the static libpq.a I didn't add the right -blibpath to this patch that failed for you - the broken initdb is dynamically linked but does not know where to look for its shared

Re: [PATCHES] [HACKERS] Linking on AIX (Was: Fix linking of OpenLDAP libraries )

2006-09-15 Thread Rocco Altier
From: Tom Lane [mailto:[EMAIL PROTECTED] Mmm ... what of make check's temporary installation? We need to have the executables search in the temporary install's libdir, *before* looking in the configured --libdir (which could easily contain an incompatible back-version libpq ...)

Re: [PATCHES] [HACKERS] Linking on AIX (Was: Fix linking of OpenLDAP libraries )

2006-09-15 Thread Rocco Altier
With the patch attached this time... -rocco -Original Message- From: Rocco Altier Sent: Friday, September 15, 2006 2:04 PM To: Rocco Altier; 'Tom Lane'; 'Albe Laurenz' Cc: 'pgsql-hackers@postgresql.org' Subject: RE: [PATCHES] [HACKERS] Linking on AIX (Was: Fix linking

Re: AIX shared libraries (was Re: [PATCHES] [HACKERS] Fix linking of OpenLDAP libraries)

2006-09-13 Thread Rocco Altier
Tom Lane wrote: Is it possible that the rules have changed across AIX versions, and that the code in there now is needful for older versions? I don't think that this behaviour has changed. I remember it from AIX 4.3.2. AIX 4.3 is the first version to support the -brtl. The current

Re: [PATCHES] [HACKERS] Fix linking of OpenLDAP libraries

2006-09-13 Thread Rocco Altier
The patch did not work for me :-( My buildfarm members failed in local testing to execute the install-check, because initdb failed to find libpq.so. Make check did succeed, so I think there is a possibility of getting it working, but it won't be as simple as adding -brtl to the template. I was

[HACKERS] BF failure - kookaburra - ecpg

2006-09-08 Thread Rocco Altier
One of the new ecpg tests for comments fails to compile the resulting .c file, because my vendor C compiler doesn't like '//' style comments, when running in C mode. Specifically its line 12 of comment.pgc: // we also understand this style It seems like ecpg should translate the comment from

Re: [HACKERS] TODO Request

2006-09-05 Thread Rocco Altier
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hannu Krosing Ühel kenal päeval, T, 2006-08-29 kell 22:12, kirjutas Joshua D. Drake: Auto creations of partitions This would be something like: create table foo () partition by ... from the referenced MySQL manual

Re: [HACKERS] ecpg test suite

2006-08-03 Thread Rocco Altier
From: Joachim Wieland [mailto:[EMAIL PROTECTED] Sent: Thursday, August 03, 2006 11:23 AM To: Tom Lane; Michael Meskes; Rocco Altier; PostgreSQL Hacker Subject: Re: [HACKERS] ecpg test suite On Thu, Aug 03, 2006 at 04:54:35PM +0200, Michael Meskes wrote: diff: `-3' option is obsolete

Re: [HACKERS] ecpg test suite

2006-08-03 Thread Rocco Altier
of that will be. BTW, I do have --enable-integer-datetimes configured for this machine, which might explain the timestamp differences. Thanks, -rocco -Original Message- From: Michael Meskes [mailto:[EMAIL PROTECTED] Sent: Thursday, August 03, 2006 9:12 AM To: Rocco Altier Cc: Michael

[HACKERS] Buildfarm failure - asp

2006-08-02 Thread Rocco Altier
Had a buildfarm failure on asp (AIX/gcc), because of an extra space in the Makefile.regress for ecpg. Attached is a patch to allow a clean compile. -rocco ecpg-test-Makefile.patch Description: ecpg-test-Makefile.patch ---(end of

Re: [HACKERS] [COMMITTERS] pgsql: another try at keeping AIX/ppc happy on cube test.

2006-07-27 Thread Rocco Altier
I think this will cause breakage for other people. Right now I think the order is unique to AIX for some reason. Recent buildfarm run of gazelle should have matched the -0 variant (cube_1.out), but did not. Also, what is worrisome is that there is an ORDER BY on the result set that is failing

[HACKERS] AIX buildfarm failure

2006-07-13 Thread Rocco Altier
I am seeing buildfarm failures on AIX because stdio.h is being included before pg_config.h (which has the definition of _LARGE_FILES). The problem is stemming from math.h including stdlib.h, which (after several more inclusions) ends up including stdio.h. This is where the fgetpos64 different

Re: [HACKERS] AIX buildfarm failure

2006-07-13 Thread Rocco Altier
:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 4:14 PM To: Tom Lane Cc: Rocco Altier; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] AIX buildfarm failure Fixed. -- - Tom Lane wrote: Rocco Altier [EMAIL

Re: [HACKERS] SO_SNDBUF size is small on win32?

2006-06-27 Thread Rocco Altier
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martijn van Oosterhout On Wed, Jun 28, 2006 at 12:23:13AM +0900, Yoshiyuki Asaba wrote: Hi, I see a performance issue on win32. This problem is causes by the following URL.

Re: [HACKERS] ANSI-strict pointer aliasing rules

2006-04-27 Thread Rocco Altier
I suspect a patch to convert PostgreSQL to C++ wouldn't be welcomed. Haha... Checking my calendar, I think you are about 26 days too late to make that suggestion... -rocco ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] FW: PGBuildfarm member asp Branch HEAD Status changed from OK to Make failure

2006-02-08 Thread Rocco Altier
It looks like all buildfarm members are failing this morning... Here is an example. -rocco -Original Message- From: PG Build Farm [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 5:32 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: PGBuildfarm member asp Branch

Re: [HACKERS] [PORTS] Failed install - libgen.so doesn't exist

2006-02-07 Thread Rocco Altier
The reason to check versions is that AIX added support for standard dlopen at 4.3 and above, which means we don't need to use the port routines built around the older library any more. -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

Re: [HACKERS] Some platform-specific MemSet research

2006-02-02 Thread Rocco Altier
I wanted to chime in that I also see this speedup from using XLC 6.0 (IBM's cc), even in 32bit mode. I have tested on AIX 5.2 and 5.1. I think this would be good to include in the regular release. Not sure how many people are running older versions of AIX that would want a new version of

Re: [HACKERS] [COMMITTERS] pgsql: Mention table in violates foreign key constraint message that

2005-12-28 Thread Rocco Altier
Does the regression test need to be updated as well for this? I am seeing a failure on my buildfarm machines. -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: Wednesday, December 28, 2005 11:47 AM To:

Re: [HACKERS] Intermittent stats test failures on buildfarm

2005-08-30 Thread Rocco Altier
Also, kookaburra (AIX) has a problem with the stats test as well. What is most puzzling to me is that it only happens with cc (not gcc). And I can only get it to happen when running a cronjob for the buildfarm. If I run it interactively, the stats collector will run fine, or if I run the build

[HACKERS] Cygwin - make check broken

2005-08-04 Thread Rocco Altier
It looks like when we changed regress/GNUmakefile to pull rules from Makefile.shlib, cygwin got broken in the process. The problem is that regess.dll ends up being a symlink back to itself, because we do a: $(NAME)$(DLSUFFIX): $(shlib) rm -f $(NAME)$(DLSUFFIX) $(LN_S) $(shlib)

Re: [HACKERS] [COMMITTERS] pgsql: Add GUC variables to control keep-alive times for idle, interval,

2005-07-30 Thread Rocco Altier
This broke the build on AIX. AIX does not have SOL_TCP as a defined symbol in any of the system header files. -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: Saturday, July 30, 2005 11:17 AM To:

Re: [HACKERS] regressin failure on latest CVS

2005-07-23 Thread Rocco Altier
, July 23, 2005 10:54 AM To: Rocco Altier Cc: Michael Glaesemann; pgsql-patches@postgresql.org; pgsql-hackers@postgresql.org; ohp@pyrenet.fr Subject: Re: [HACKERS] regressin failure on latest CVS Rocco Altier wrote: This patch fixes the interval regression on my AIX box (kookaburra

Re: [HACKERS] regressin failure on latest CVS

2005-07-22 Thread Rocco Altier
This patch fixes the interval regression on my AIX box (kookaburra) by only doing integer math on the interval, instead of float/double math. I think this is the correct way to handle this, since it's an integer data type. I don't know if it will fix Olivier's problem, since I wasn't able to

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-18 Thread Rocco Altier
On Tue, 18 Nov 2003, ow wrote: Have *never* seen ppl running Oracle or Sybase on Windows. I can't speak for Oracle, but Sybase on Windows is definitely a real thing. If you have to deal with developing for their iAnywhere product (a remote replication solution for PocketPC applications),

Re: [HACKERS] IPv6 patch

2003-01-07 Thread Rocco Altier
Another idea is to have the -i take an optional argument. Something where -i means bind to both v4 and v6, and -i4 means to only v4, and -i6 to only v6. I am guessing that most people will want to bind to both when they just specify -i, which is what is usually suggested when they want to get

Re: [HACKERS] Non-standard feature request

2002-06-14 Thread Rocco Altier
On Fri, 14 Jun 2002, Mike Mascari wrote: That is what I want to do, except by extending the grammar. I must admit to actually being surprised that a TEMP table created inside a transaction lived after the transaction completed. That's when I looked at the standard and saw that PostgreSQL's

RE: [HACKERS] Packaging 7.1.1

2001-05-04 Thread Rocco Altier
On Thu, 3 May 2001, Rachit Siamwalla wrote: 1. `pidof` should be `pidof -s` (2 instances) 2. restart) should be stop; sleep x; start ideally, stop should actually wait till postgres fully stops. The sleep is just a temporary fix. Perhaps a naive question, but why not use the pg_ctl for