Jim C. Nasby wrote:
On Mon, Dec 12, 2005 at 10:39:47PM -0500, Tom Lane wrote:
"Andrew Dunstan" <[EMAIL PROTECTED]> writes:
I think I'd just delete lines 464-470 in
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-auth.c?annotate=1.71
I confirmed that this is the patch appearing in 7.4 (fe-auth.c rev
1.84), so went ahead and applied it to 7.3.
Seems to have worked... but now there's another problem...
I don't know if this is yet another one, but happened to rebuild 7.3.12
on a FreeBSD 6.0 box today and I notice that it fails float8 regression
test (geometry does too but that is marked as ignorable).
This is with the informal patch applied to fe-auth.c.
(see attached regression.diff).
regards
Mark
*** ./expected/float8-small-is-zero.out Wed Oct 23 09:01:15 2002
--- ./results/float8.out Thu Dec 15 12:17:34 2005
***************
*** 274,280 ****
--- 274,282 ----
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
ERROR: Input '-10e400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
+ ERROR: Input '10e-400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
+ ERROR: Input '-10e-400' is out of range for float8
-- maintain external table consistency across platforms
-- delete all values and reinsert well-behaved ones
DELETE FROM FLOAT8_TBL;
======================================================================
*** ./expected/geometry-positive-zeros-bsd.out Wed Sep 13 09:07:16 2000
--- ./results/geometry.out Thu Dec 15 12:18:24 2005
***************
*** 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)
***************
*** 224,233 ****
twentyfour | rotation
------------+-----------------------------
| (0,0),(0,0)
! | (0,0),(-20,-20)
! | (0,2),(-14,0)
| (0,79.2),(-58.8,0)
! | (14,0),(0,-34)
| (0,40),(0,0)
| (0,0),(0,0)
| (-10,-10),(-30,-30)
--- 224,233 ----
twentyfour | rotation
------------+-----------------------------
| (0,0),(0,0)
! | (-0,0),(-20,-20)
! | (-0,2),(-14,0)
| (0,79.2),(-58.8,0)
! | (14,-0),(0,-34)
| (0,40),(0,0)
| (0,0),(0,0)
| (-10,-10),(-30,-30)
***************
*** 254,264 ****
WHERE (p.f1 <-> point '(0,0)') >= 1;
twenty | rotation
--------+-----------------------------------------------------------------------------------
! | (0,0),(-0.2,-0.2)
| (-0.1,-0.1),(-0.3,-0.3)
| (-0.25,-0.25),(-0.25,-0.35)
| (-0.3,-0.3),(-0.3,-0.3)
! | (0.08,0),(0,-0.56)
| (0.12,-0.28),(0.04,-0.84)
| (0.26,-0.7),(0.1,-0.82)
| (0.12,-0.84),(0.12,-0.84)
--- 254,264 ----
WHERE (p.f1 <-> point '(0,0)') >= 1;
twenty | rotation
--------+-----------------------------------------------------------------------------------
! | (0,-0),(-0.2,-0.2)
| (-0.1,-0.1),(-0.3,-0.3)
| (-0.25,-0.25),(-0.25,-0.35)
| (-0.3,-0.3),(-0.3,-0.3)
! | (0.08,-0),(0,-0.56)
| (0.12,-0.28),(0.04,-0.84)
| (0.26,-0.7),(0.1,-0.82)
| (0.12,-0.84),(0.12,-0.84)
***************
*** 266,272 ****
|
(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
|
(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
|
(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
! | (0,0.0828402366863905),(-0.201183431952663,0)
|
(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
|
(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
|
(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
--- 266,272 ----
|
(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
|
(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
|
(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
! | (-0,0.0828402366863905),(-0.201183431952663,0)
|
(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
|
(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
|
(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly