Re: RC1? AIX 4.2.1.0 (fwd) - Mailing list pgsql-hackers

From Samuel A Horwitz
Subject Re: RC1? AIX 4.2.1.0 (fwd)
Date
Msg-id Pine.A32.3.91.1021125090916.34504B-100000@argos
Whole thread Raw
List pgsql-hackers
Sorry forgot to include that I had to add -lssl and -lcrypto ti the libpq 
line in Makefile.global.in in the src directory to get ecpg to link

as follows

286c286
< libpq = -L$(libpq_builddir) -lpq
---
> libpq = -L$(libpq_builddir) -lpq -lssl -lcrypto


horwitz@argoscomp.com (Samuel A Horwitz)


---------- Forwarded message ----------
Date: Mon, 25 Nov 2002 08:45:46 -0500 (EST)
From: Samuel A Horwitz <horwitz@argoscomp.com>
To: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] RC1? AIX 4.2.1.0 

system = powerpc-ibm-aix4.2.1.0 


configure command 

env CC=gcc ./configure --with-maxbackends=1024 --with-openssl=/usr/local/ssl --enable-syslog --enable-odbc
--disable-nls

gmake check output file


regression.out
--------------

parallel group (13 tests):  text varchar oid int2 char boolean float4 int4 name int8 float8 bit numeric    boolean
       ... ok    char                 ... ok    name                 ... ok    varchar              ... ok    text
          ... ok    int2                 ... ok    int4                 ... ok    int8                 ... ok    oid
             ... ok    float4               ... ok    float8               ... ok    bit                  ... ok
numeric             ... ok
 
test strings              ... ok
test numerology           ... ok
parallel group (20 tests):  lseg date path circle polygon box point time timetz tinterval abstime interval reltime
commentsinet timestamptz timestamp type_sanity opr_sanity oidjoins    point                ... ok    lseg
 ... ok    box                  ... ok    path                 ... ok    polygon              ... ok    circle
    ... ok    date                 ... ok    time                 ... ok    timetz               ... ok    timestamp
       ... ok    timestamptz          ... ok    interval             ... ok    abstime              ... ok    reltime
          ... ok    tinterval            ... ok    inet                 ... ok    comments             ... ok
oidjoins            ... ok    type_sanity          ... ok    opr_sanity           ... ok
 
test geometry             ... FAILED
test horology             ... ok
test insert               ... ok
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok
parallel group (7 tests):  create_aggregate create_operator triggers vacuum inherit constraints create_misc
constraints         ... ok    triggers             ... ok    create_misc          ... ok    create_aggregate     ... ok
  create_operator      ... ok    inherit              ... ok    vacuum               ... ok
 
parallel group (2 tests):  create_view create_index    create_index         ... ok    create_view          ... ok
test sanity_check         ... ok
test errors               ... ok
test select               ... ok
parallel group (16 tests):  select_distinct_on select_into select_having transactions select_distinct random subselect
portalsarrays union select_implicit case aggregates hash_index join btree_index    select_into          ... ok
select_distinct     ... ok    select_distinct_on   ... ok    select_implicit      ... ok    select_having        ... ok
  subselect            ... ok    union                ... ok    case                 ... ok    join                 ...
ok   aggregates           ... ok    transactions         ... ok    random               ... ok    portals
...ok    arrays               ... ok    btree_index          ... ok    hash_index           ... ok
 
test privileges           ... ok
test misc                 ... ok
parallel group (5 tests):  portals_p2 cluster rules select_views foreign_key    select_views         ... ok
portals_p2          ... ok    rules                ... ok    foreign_key          ... ok    cluster              ...
ok
parallel group (11 tests):  limit truncate temp copy2 domain rangefuncs conversion prepare without_oid plpgsql
alter_table   limit                ... ok    plpgsql              ... ok    copy2                ... ok    temp
       ... ok    domain               ... ok    rangefuncs           ... ok    prepare              ... ok
without_oid         ... ok    conversion           ... ok    truncate             ... ok    alter_table          ...
ok


regression.diffs
-----------------


*** ./expected/geometry-powerpc-aix4.out    Tue Sep 12 17:07:16 2000
--- ./results/geometry.out    Thu Nov 21 21:46:01 2002
***************
*** 114,120 ****         | (5.1,34.5) | [(1,2),(3,4)]                 | (3,4)         | (-5,-12)   | [(1,2),(3,4)]
          | (1,2)         | (10,10)    | [(1,2),(3,4)]                 | (3,4)
 
!         | (0,0)      | [(0,0),(6,6)]                 | (0,0)         | (-10,0)    | [(0,0),(6,6)]                 |
(0,0)        | (-3,4)     | [(0,0),(6,6)]                 | (0.5,0.5)         | (5.1,34.5) | [(0,0),(6,6)]
  | (6,6)
 
--- 114,120 ----         | (5.1,34.5) | [(1,2),(3,4)]                 | (3,4)         | (-5,-12)   | [(1,2),(3,4)]
          | (1,2)         | (10,10)    | [(1,2),(3,4)]                 | (3,4)
 
!         | (0,0)      | [(0,0),(6,6)]                 | (-0,0)         | (-10,0)    | [(0,0),(6,6)]                 |
(0,0)        | (-3,4)     | [(0,0),(6,6)]                 | (0.5,0.5)         | (5.1,34.5) | [(0,0),(6,6)]
  | (6,6)
 
***************
*** 127,133 ****         | (-5,-12)   | [(10,-10),(-3,-4)]            | (-1.60487804878049,-4.64390243902439)         |
(10,10)   | [(10,-10),(-3,-4)]            | (2.39024390243902,-6.48780487804878)         | (0,0)      |
[(-1000000,200),(300000,-40)]| (0.0028402365895872,15.384614860264)
 
!         | (-10,0)    | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473)         | (-3,4)     |
[(-1000000,200),(300000,-40)]| (-2.99789812267519,15.3851688427303)         | (5.1,34.5) |
[(-1000000,200),(300000,-40)]| (5.09647083221496,15.3836744976925)         | (-5,-12)   | [(-1000000,200),(300000,-40)]
|(-4.99494420845634,15.3855375281616)
 
--- 127,133 ----         | (-5,-12)   | [(10,-10),(-3,-4)]            | (-1.60487804878049,-4.64390243902439)         |
(10,10)   | [(10,-10),(-3,-4)]            | (2.39024390243902,-6.48780487804878)         | (0,0)      |
[(-1000000,200),(300000,-40)]| (0.0028402365895872,15.384614860264)
 
!         | (-10,0)    | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472)         | (-3,4)     |
[(-1000000,200),(300000,-40)]| (-2.99789812267519,15.3851688427303)         | (5.1,34.5) |
[(-1000000,200),(300000,-40)]| (5.09647083221496,15.3836744976925)         | (-5,-12)   | [(-1000000,200),(300000,-40)]
|(-4.99494420845634,15.3855375281616)
 
***************
*** 448,454 ****      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994

107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081027))
    |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.4999999999

6464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999

999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
!      |
((-0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999

999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
(6rows)  -- convert the circle to an 8-point polygon
 
--- 448,454 ----      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994

107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081027))
    |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.4999999999

6464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
    |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999

999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
!      |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.9999

99998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
(6rows)  -- convert the circle to an 8-point polygon
 
***************
*** 461,467 ****      |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
    |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
    |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      |
((-0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6rows)  --
 
--- 461,467 ----      |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
    |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
    |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6rows)  --
 

======================================================================

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



pgsql-hackers by date:

Previous
From: Samuel A Horwitz
Date:
Subject: Re: RC1? AIX 4.2.1.0
Next
From: "Marc G. Fournier"
Date:
Subject: RC2 Packaged in Preparation for a Wednesday Release ...