Thread

  1. Re: RC2? AIX 4.2.1.0 (fwd)

    Samuel A Horwitz <horwitz@argoscomp.com> — 2002-11-26T13:46:32Z

    Problem still exists in RC2
    
    
    horwitz@argoscomp.com (Samuel A Horwitz)
    
    
    ---------- Forwarded message ----------
    Date: Mon, 25 Nov 2002 09:12:55 -0500 (EST)
    From: Samuel A Horwitz <horwitz@argoscomp.com>
    To: pgsql-hackers@postgresql.org
    Subject: Re: [HACKERS] RC1? AIX 4.2.1.0 (fwd)
    
    Sorry forgot to include that I had to add -lssl and -lcrypto t0 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 comments inet 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 portals arrays 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))
      (6 rows)
      
      -- 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))
      (6 rows)
      
      -- 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))
      (6 rows)
      
      --
    --- 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))
      (6 rows)
      
      --
    
    ======================================================================
    
    ---------------------------(end of broadcast)---------------------------
    TIP 6: Have you searched our list archives?
    
    http://archives.postgresql.org
    
    
    ---------------------------(end of broadcast)---------------------------
    TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org