Re: [PATCHES] [HACKERS] [COMMITTERS] pgsql: /contrib/cube improvements:

2006-07-27 Thread Rocco Altier
There is also an issue with PPC processors with +/-0 in the cube test: *** ./expected/cube.out Thu Jul 27 05:23:14 2006 --- ./results/cube.out Thu Jul 27 05:43:21 2006 *** *** 144,150 SELECT '-1e-700'::cube AS cube; cube -- ! (0) (1 row) SELECT '1234567890123456'

Re: [PATCHES] [PATCH] Improve EXPLAIN ANALYZE overhead by sampling

2006-05-09 Thread Rocco Altier
> - To get this close it needs to get an estimate of the sampling overhead. > It does this by a little calibration loop that is run once per backend. > If you don't do this, you end up assuming all tuples take the same time > as tuples with the overhead, resulting in nodes apparently taking > longe

Re: [PATCHES] [HACKERS] pgxs/windows

2006-01-19 Thread Rocco Altier
been installed in $libdir. Thanks, -rocco > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 19, 2006 6:28 PM > To: Rocco Altier > Cc: Bruce Momjian; Andrew Dunstan; Magnus Hagander; PostgreSQL-patches > Subject: Re: [PATCHES]

Re: [PATCHES] [HACKERS] pgxs/windows

2006-01-19 Thread Rocco Altier
If I understand correctly, atleast for the AIX case, the reason that Makefile.aix is referencing DESTDIR is for the PGXS case. I thought that PGXS was supposed to be able to be run after things were installed, and you might not have the compile tree anymore. Basically, if you wanted to build some

Re: [PATCHES] AIX - pgport/contrib resolution

2005-08-02 Thread Rocco Altier
Thanks for getting this in. AIX is now green in 8.0 *happy dance* -rocco > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, August 01, 2005 9:36 PM > To: Rocco Altier > Cc: Andrew Dunstan; pgsql-patches@postgresql.org > Subject:

Re: [PATCHES] AIX - pgport/contrib resolution

2005-07-28 Thread Rocco Altier
rsday, July 28, 2005 9:53 AM > To: Tom Lane > Cc: Rocco Altier; pgsql-patches@postgresql.org > Subject: Re: [PATCHES] AIX - pgport/contrib resolution > > > > > Tom Lane wrote: > > >Pushed these in too ... hope to see a green board on the AIX > buildfarm &g

[PATCHES] AIX - pgport/contrib resolution

2005-07-27 Thread Rocco Altier
The comment in regress/GNUmakefile about the pgport symbols not being found got me thinking about why that might be the case. I finally noticed that when we are building the postgres.imp file, we are not pulling in the pgport symbols, since they are not being linked into the local SUBSYS.o before

Re: [PATCHES] Proposed patch to remove .so pattern rules from platform Makefiles

2005-07-26 Thread Rocco Altier
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > > "Rocco Altier" <[EMAIL PROTECTED]> writes: > > Please disregard this patch. I have a ton of lib%.exp and > > similar files created currently. > > Yeah, that was one of t

Re: [PATCHES] Proposed patch to remove .so pattern rules from platform Makefiles

2005-07-26 Thread Rocco Altier
Please disregard this patch. I have a ton of lib%.exp and similar files created currently. I am working on a new patch to deal with the MODULES expansion correctly. Thanks, -rocco > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf

Re: [PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-25 Thread Rocco Altier
x - patch attached. Thanks -rocco (desperate to get AIX green on buildfarm) > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Sunday, July 24, 2005 7:34 PM > To: Rocco Altier > Cc: Patches (PostgreSQL) > Subject: Re: [PATCHES] Regressio

Re: [PATCHES] Proposed patch to remove .so pattern rules from platform Makefiles

2005-07-25 Thread Rocco Altier
The patch works on AIX with one small tweak to Makefile.shlib (attached). This is needed because of the clever trick with using % as name, and when its evaulated for the mkldexport. Also, it appears that the changes for regress/GNUmakefile are already applied. I am able to build everything and p

Re: [PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-24 Thread Rocco Altier
This time I actually have the patches :-) -rocco > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Rocco Altier > Sent: Sunday, July 24, 2005 1:15 PM > To: Tom Lane > Cc: Patches (PostgreSQL) > Subject: Re: [PATCHES] Reg

Re: [PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-24 Thread Rocco Altier
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: Sunday, July 24, 2005 10:47 AM > To: Rocco Altier > Cc: Patches (PostgreSQL) > Subject: Re: [PATCHES] Regression - GNUmakefile - pg_usleep > > > &q

Re: [PATCHES] fix integer datetime division rounding error

2005-07-23 Thread Rocco Altier
This fixes the problem for me. Thanks, -rocco > -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > Sent: Sunday, July 24, 2005 12:37 AM > To: Andrew Dunstan > Cc: Patches (PostgreSQL); Rocco Altier > Subject: Re: [PATCHES] fix integer datetime

[PATCHES] Regression - GNUmakefile - pg_usleep

2005-07-23 Thread Rocco Altier
Attached patch fixes the SHLIB_LINK to add pgport now that pg_usleep is added. This is needed for AIX to resolve symbols at compile time. This is also to be used in conjuction with the other patch I have pending for Makefile.aix to SHLIB_LINK instead of LIBS to compile shared objects. Thanks,

Re: [PATCHES] [HACKERS] regressin failure on latest CVS

2005-07-23 Thread Rocco Altier
> Sent: Saturday, July 23, 2005 2:51 PM > To: Rocco Altier > Cc: Michael Glaesemann; pgsql-patches@postgresql.org; ohp@pyrenet.fr > Subject: Re: [HACKERS] regressin failure on latest CVS > > > > Would you please try the attached patch and let me know if it >

Re: [PATCHES] [HACKERS] regressin failure on latest CVS

2005-07-23 Thread Rocco Altier
Sent: Saturday, 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 fi

Re: [PATCHES] [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 repr

Re: [PATCHES] Changes for AIX buildfarm

2005-07-21 Thread Rocco Altier
osely the link rules from Makefile.shlib. -rocco > -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 20, 2005 2:12 PM > To: Rocco Altier > Cc: pgsql-patches@postgresql.org; Tom Lane; Andrew Dunstan; > Zeugswetter Andre

Re: [PATCHES] [COMMITTERS] pgsql: Add 'day' field to INTERVAL so 1 day interval

2005-07-20 Thread Rocco Altier
This is also broken for make check with --enable-integer-datetimes on kookaburra (AIX). It looks like the other members of buildfarm that fail on contrib aren't using integer datetimes. -rocco > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf O

Re: [PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
that userlocks is using MODULES which is working correctly. I will dig further and come up with another patch. -rocco > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, July 18, 2005 12:47 PM > To: Andrew Dunstan > Cc: Rocco Altier; Zeug

Re: [PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
L PROTECTED] > Sent: Monday, July 18, 2005 12:47 PM > To: Andrew Dunstan > Cc: Rocco Altier; Zeugswetter Andreas DAZ SD; > pgsql-patches@postgresql.org > Subject: Re: [PATCHES] Changes for AIX buildfarm > > > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > Tom

Re: [PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
-rocco > -Original Message- > From: Andrew Dunstan [mailto:[EMAIL PROTECTED] > Sent: Monday, July 18, 2005 12:42 PM > To: Tom Lane > Cc: Rocco Altier; pgsql-patches@postgresql.org > Subject: Re: [PATCHES] Changes for AIX buildfarm > > > > > To

[PATCHES] Changes for AIX buildfarm

2005-07-18 Thread Rocco Altier
Need to have these patches applied to get AIX 5.2 to build as a member of the buildfarm. The Makefile.shlib patch allows all the contrib modules to build (this seems to be the same problem that cygwin is facing). AIX needs -lm (to pick up math routines for atleast cube module). I am not sure why