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