Porting effort and patches for the Irix port for PostgreSQL - Mailing list pgsql-hackers
| From | Robert Bruccoleri |
|---|---|
| Subject | Porting effort and patches for the Irix port for PostgreSQL |
| Date | |
| Msg-id | 199809120324.XAA17887@pluto.njcc.com Whole thread Raw |
| Responses |
Re: Porting effort and patches for the Irix port for PostgreSQL
|
| List | pgsql-hackers |
I have partially ported the PostgreSQL snapshot of September 9 to Irix
and wanted to report the results to you so that you could enter the
corrections into the source tree. Please let me know if you want
me to rerun or retest anything. Because of time constraints, I may not
be able to respond right away, but I will do my best to get PostgreSQL
6.4 released on time.
There were several problems compiling the program. First, the configure
script uses the wrong format for int8. The following patch corrects the
problem on Irix.
*** ./src/configure Thu Sep 10 21:46:40 1998
--- ./src/configure.~1~ Wed Sep 2 03:00:33 1998
***************
*** 3720,3726 ****
#include "confdefs.h"
#include <stdio.h>
typedef long long int int64;
! #define INT64_FORMAT "%lld"
int64 a = 20000001;
int64 b = 40000005;
--- 3720,3726 ----
#include "confdefs.h"
#include <stdio.h>
typedef long long int int64;
! #define INT64_FORMAT "%Ld"
int64 a = 20000001;
int64 b = 40000005;
========================================================================
Next, the snprintf function does not compile or link correctly.
I don't know an easy to make equivalent functionality, so I removed the
call in int8.c for now. Obviously, snprintf has to be
resolved.
*** ./src/backend/utils/adt/int8.c Fri Sep 11 21:30:57 1998
--- ./src/backend/utils/adt/int8.c.~1~ Tue Sep 1 03:01:35 1998
***************
*** 66,72 ****
if (!PointerIsValid(val))
return NULL;
! if ((len = sprintf(buf, INT64_FORMAT, *val)) < 0)
elog(ERROR, "Unable to format int8", NULL);
result = palloc(len + 1);
--- 66,72 ----
if (!PointerIsValid(val))
return NULL;
! if ((len = snprintf(buf, MAXINT8LEN, INT64_FORMAT, *val)) < 0)
elog(ERROR, "Unable to format int8", NULL);
result = palloc(len + 1);
========================================================================
There is a GNUism remaining in the following file.
*** ./src/backend/storage/lmgr/lock.c Wed Sep 9 21:07:58 1998
--- ./src/backend/storage/lmgr/lock.c.~1~ Tue Sep 1 03:01:25 1998
***************
*** 136,142 ****
xidentP->holders[5], \
xidentP->nHolding)
! #define LOCK_TPRINTF(lock, args) \
if (((LOCKDEBUG(LOCK_LOCKMETHOD(*(lock))) >= 1) \
&& (lock->tag.relId >= lockDebugOidMin)) \
|| (lock->tag.relId == lockDebugRelation)) \
--- 136,142 ----
xidentP->holders[5], \
xidentP->nHolding)
! #define LOCK_TPRINTF(lock, args...) \
if (((LOCKDEBUG(LOCK_LOCKMETHOD(*(lock))) >= 1) \
&& (lock->tag.relId >= lockDebugOidMin)) \
|| (lock->tag.relId == lockDebugRelation)) \
***************
*** 147,153 ****
#define LOCK_PRINT_AUX(where,lock,type)
#define XID_PRINT(where,xidentP)
#define XID_PRINT_AUX(where,xidentP)
! #define LOCK_TPRINTF(lock, args)
#endif /* !LOCK_MGR_DEBUG */
static char *lock_types[] = {
--- 147,153 ----
#define LOCK_PRINT_AUX(where,lock,type)
#define XID_PRINT(where,xidentP)
#define XID_PRINT_AUX(where,xidentP)
! #define LOCK_TPRINTF(lock, args...)
#endif /* !LOCK_MGR_DEBUG */
static char *lock_types[] = {
========================================================================
The following patch is critical to getting proper lock function
on the SGI's. This is the most important patch for Irix.
*** ./src/include/port/irix5.h Fri Sep 11 07:40:47 1998
--- ./src/include/port/irix5.h.~1~ Sun Sep 7 00:59:54 1997
***************
*** 3,6 ****
#define NO_EMPTY_STMTS
#define SYSV_DIRENT
#define HAS_TEST_AND_SET
! typedef unsigned long slock_t;
--- 3,7 ----
#define NO_EMPTY_STMTS
#define SYSV_DIRENT
#define HAS_TEST_AND_SET
! #include <abi_mutex.h>
! typedef abilock_t slock_t;
*** ./src/include/storage/s_lock.h Fri Sep 11 07:40:47 1998
--- ./src/include/storage/s_lock.h.~1~ Tue Sep 1 03:02:25 1998
***************
*** 265,275 ****
* assembly from his NECEWS SVR4 port, but we probably ought to retain this
* for the R3000 chips out there.
*/
! #include <mutex.h>
! #define TAS(lock) (test_and_set(lock,1))
! #define S_UNLOCK(lock) (test_then_and(lock,0))
! #define S_INIT_LOCK(lock) (test_then_and(lock,0))
! #define S_LOCK_FREE(lock) (test_then_add(lock,0) == 0)
#endif /* __sgi */
--- 265,274 ----
* assembly from his NECEWS SVR4 port, but we probably ought to retain this
* for the R3000 chips out there.
*/
! #define TAS(lock) (!acquire_lock(lock))
! #define S_UNLOCK(lock) release_lock(lock)
! #define S_INIT_LOCK(lock) init_lock(lock)
! #define S_LOCK_FREE(lock) (stat_lock(lock) == UNLOCKED)
#endif /* __sgi */
========================================================================
The interfaces Makefile does not get defined properly for the C++
compilations. On my system, the SGI C++ compiler is installed,
but the Makefile is built to use g++ and therefore the Makefile
fails. The following works on my system, but doesn't solve the
configuration problem.
*** ./src/interfaces/Makefile Wed Sep 9 21:18:50 1998
--- ./src/interfaces/Makefile.~1~ Thu Aug 27 03:00:35 1998
***************
*** 24,40 ****
.DEFAULT all install clean dep depend distclean: $(perl-makefile-dep)
$(MAKE) -C libpq $@
$(MAKE) -C ecpg $@
! # ifeq ($(HAVE_Cplusplus), true)
! # $(MAKE) -C libpq++ $@
! # else
! # echo $(HAVE_Cplusplus): No C++
! # endif
ifeq ($(USE_TCL), true)
$(MAKE) -C libpgtcl $@
endif
! # ifeq ($(USE_PERL), true)
! # $(MAKE) -C perl5 $@
! # endif
perl5/Makefile: perl5/Makefile.PL
cd perl5 && perl Makefile.PL
--- 24,40 ----
.DEFAULT all install clean dep depend distclean: $(perl-makefile-dep)
$(MAKE) -C libpq $@
$(MAKE) -C ecpg $@
! ifeq ($(HAVE_Cplusplus), true)
! $(MAKE) -C libpq++ $@
! else
! echo $(HAVE_Cplusplus): No C++
! endif
ifeq ($(USE_TCL), true)
$(MAKE) -C libpgtcl $@
endif
! ifeq ($(USE_PERL), true)
! $(MAKE) -C perl5 $@
! endif
perl5/Makefile: perl5/Makefile.PL
cd perl5 && perl Makefile.PL
========================================================================
Here are differences found for all the regression tests:
::::::::::::::
abstime.out.dif
::::::::::::::
25c25
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
38c38
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
50c50
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
78c78
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
88c88
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
109c109
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
119c119
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
129c129
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
139c139
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
148,152c148,152
< |Sat May 10 23:59:12 1947 PDT|@ 14 secs ago
< |Sat May 10 23:59:12 1947 PDT|@ 1 min
< |Sat May 10 23:59:12 1947 PDT|@ 5 hours
< |Sat May 10 23:59:12 1947 PDT|@ 10 days
< |Sat May 10 23:59:12 1947 PDT|@ 3 mons
---
> |Sat May 10 23:59:12 1947 PST|@ 14 secs ago
> |Sat May 10 23:59:12 1947 PST|@ 1 min
> |Sat May 10 23:59:12 1947 PST|@ 5 hours
> |Sat May 10 23:59:12 1947 PST|@ 10 days
> |Sat May 10 23:59:12 1947 PST|@ 3 mons
::::::::::::::
alter_table.out.dif
::::::::::::::
13c13
< ERROR: type name lookup of dt failed
---
> ERROR: type name lookup of dt failed
36c36
< ERROR: Relation temp does not have attribute k
---
> ERROR: Relation temp does not have attribute k
57c57
< ERROR: type name lookup of dt failed
---
> ERROR: type name lookup of dt failed
80c80
< ERROR: Relation temp does not have attribute k
---
> ERROR: Relation temp does not have attribute k
::::::::::::::
float8.out.dif
::::::::::::::
206c206,214
< ERROR: exp() result is out of range
---
> bad| ?column?
> ---+--------------------
> | 1
> |7.39912306090513e-16
> | 0
> | 0
> | 1
> (5 rows)
>
::::::::::::::
geometry.out.dif
::::::::::::::
102c102
< |(0,0) |[(0,0),(6,6)] |(0,0)
---
> |(0,0) |[(0,0),(6,6)] |(-0,0)
115c115
< |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
---
> |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473)
132,134c132,134
< |(71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547)
< |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
< |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
---
> |(71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548)
> |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
> |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643)
136c136
< |(170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)
---
> |(170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)
207c207
< |(0,0),(-20,-20)
---
> |(-0,0),(-20,-20)
211c211
< |(0,2),(-14,0)
---
> |(-0,2),(-14,0)
219c219
< |(14,0),(0,-34)
---
> |(14,-0),(0,-34)
234c234
< |(0,0),(-0.2,-0.2)
---
> |(0,-0),(-0.2,-0.2)
238c238
< |(0.08,0),(0,-0.56)
---
> |(0.08,-0),(0,-0.56)
246c246
< |(0,0.0828402366863905),(-0.201183431952663,0)
---
> |(-0,0.0828402366863905),(-0.201183431952663,0)
411,418c411,418
< six|polygon
<
---+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<
|((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53104195987908e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06208391975815e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59312587963723e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138139,-1.49999999995138))
<
|((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051035,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897931),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468958,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794))
<
|((-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.499999999948436),(3.49999999994107,-1.33012701895622),(0.999999999923448,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081029))
<
|((-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.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138139,0.500000000048617))
<
|((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.999999999882,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.02069463991938e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794))
---
> six|polygon
>
---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
|((-3,0),(-2.59807621135332,1.5),(-1.5,2.59807621135332),(-1.83690953073357e-16,3),(1.5,2.59807621135332),(2.59807621135332,1.5),(3,3.67381906146713e-16),(2.59807621135332,-1.5),(1.5,-2.59807621135332),(5.5107285922007e-16,-3),(-1.5,-2.59807621135332),(-2.59807621135332,-1.5))
>
|((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,102),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.6025403784439),(-85.6025403784438,-48))
>
|((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.33012701892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001),(3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0.499999999999998))
>
|((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.59807621135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001),(2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332,0.499999999999999))
>
|((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.660254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,191.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195))
>
|((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.6025403784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444,-50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.3974596215562,-50))
423,430c423,430
< six|polygon
<
---+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<
|((-3,0),(-2.12132034355423,2.12132034356506),(1.53104195987908e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06208391975815e-11),(2.12132034353258,-2.12132034358671),(-4.59312587963723e-11,-3),(-2.12132034359753,-2.12132034352175))
<
|((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051035,102),(71.7106781191961,72.7106781181134),(101,1.99999999897931),(71.7106781177526,-68.7106781195569),(0.999999998468958,-98),(-69.7106781199178,-68.7106781173917))
<
|((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923448,-2),(-2.53553390599589,-0.535533905869586))
<
|((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586708),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521751))
<
|((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.7106781181134),(200,-1.02069463991938e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
---
> six|polygon
>
---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
|((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964))
>
|((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68.7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548))
>
|((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738))
>
|((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643))
>
|((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135))
>
|((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547),(100,-100),(29.2893218813453,-70.7106781186548))
468,493c468,493
< twentyfour|circle |point | distance
< ----------+--------------+----------+----------------
< |<(100,0),100> |(5.1,34.5)|0.97653192697797
< |<(1,2),3> |(-3,4) |1.47213595499958
< |<(0,0),3> |(-3,4) | 2
< |<(100,0),100> |(-3,4) |3.07764064044152
< |<(100,0),100> |(-5,-12) |5.68348972285122
< |<(1,3),5> |(-10,0) |6.40175425099138
< |<(1,3),5> |(10,10) |6.40175425099138
< |<(0,0),3> |(-10,0) | 7
< |<(1,2),3> |(-10,0) |8.18033988749895
< |<(1,2),3> |(10,10) | 9.0415945787923
< |<(0,0),3> |(-5,-12) | 10
< |<(100,0),100> |(-10,0) | 10
< |<(0,0),3> |(10,10) | 11.142135623731
< |<(1,3),5> |(-5,-12) |11.1554944214035
< |<(1,2),3> |(-5,-12) |12.2315462117278
< |<(1,3),5> |(5.1,34.5)|26.7657047773223
< |<(1,2),3> |(5.1,34.5)| 29.757594539282
< |<(0,0),3> |(5.1,34.5)|31.8749193547455
< |<(100,200),10>|(5.1,34.5)|180.778038568384
< |<(100,200),10>|(10,10) |200.237960416286
< |<(100,200),10>|(-3,4) |211.415898254845
< |<(100,200),10>|(0,0) |213.606797749979
< |<(100,200),10>|(-10,0) |218.254244210267
< |<(100,200),10>|(-5,-12) |226.577682802077
---
> twentyfour|circle |point | distance
> ----------+--------------+----------+-----------------
> |<(100,0),100> |(5.1,34.5)|0.976531926977964
> |<(1,2),3> |(-3,4) | 1.47213595499958
> |<(0,0),3> |(-3,4) | 2
> |<(100,0),100> |(-3,4) | 3.07764064044151
> |<(100,0),100> |(-5,-12) | 5.68348972285122
> |<(1,3),5> |(-10,0) | 6.40175425099138
> |<(1,3),5> |(10,10) | 6.40175425099138
> |<(0,0),3> |(-10,0) | 7
> |<(1,2),3> |(-10,0) | 8.18033988749895
> |<(1,2),3> |(10,10) | 9.0415945787923
> |<(0,0),3> |(-5,-12) | 10
> |<(100,0),100> |(-10,0) | 10
> |<(0,0),3> |(10,10) | 11.142135623731
> |<(1,3),5> |(-5,-12) | 11.1554944214035
> |<(1,2),3> |(-5,-12) | 12.2315462117278
> |<(1,3),5> |(5.1,34.5)| 26.7657047773224
> |<(1,2),3> |(5.1,34.5)| 29.757594539282
> |<(0,0),3> |(5.1,34.5)| 31.8749193547455
> |<(100,200),10>|(5.1,34.5)| 180.778038568384
> |<(100,200),10>|(10,10) | 200.237960416286
> |<(100,200),10>|(-3,4) | 211.415898254845
> |<(100,200),10>|(0,0) | 213.606797749979
> |<(100,200),10>|(-10,0) | 218.254244210267
> |<(100,200),10>|(-5,-12) | 226.577682802077
::::::::::::::
horology.out.dif
::::::::::::::
433c433
< |Sat May 10 23:59:12 1947 PDT|1947| 5| 10| 23| 59| 12
---
> |Sat May 10 23:59:12 1947 PST|1947| 5| 10| 23| 59| 12
480c480
< |Sat May 10 23:59:12 1947 PDT|05-10-1947
---
> |Sat May 10 23:59:12 1947 PST|05-10-1947
614c614
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
695c695
< |1947-05-10 23:59:12-07
---
> |1947-05-10 23:59:12-08
778c778
< |05/10/1947 23:59:12.00 PDT
---
> |05/10/1947 23:59:12.00 PST
869c869
< |Sat 10 May 23:59:12 1947 PDT
---
> |Sat 10 May 23:59:12 1947 PST
953c953
< |1947-05-10 23:59:12-07
---
> |1947-05-10 23:59:12-08
1037c1037
< |10/05/1947 23:59:12.00 PDT
---
> |10/05/1947 23:59:12.00 PST
1124c1124
< |Sat May 10 23:59:12 1947 PDT
---
> |Sat May 10 23:59:12 1947 PST
1206c1206
< |1947-05-10 23:59:12-07
---
> |1947-05-10 23:59:12-08
1290c1290
< |05/10/1947 23:59:12.00 PDT
---
> |05/10/1947 23:59:12.00 PST
1382c1382
< |Sat 10 May 23:59:12 1947 PDT
---
> |Sat 10 May 23:59:12 1947 PST
1467c1467
< |1947-05-10 23:59:12-07
---
> |1947-05-10 23:59:12-08
1552c1552
< |10/05/1947 23:59:12.00 PDT
---
> |10/05/1947 23:59:12.00 PST
::::::::::::::
int2.out.dif
::::::::::::::
10c10
< ERROR: pg_atoi: error reading "100000": Result too large
---
> ERROR: pg_atoi: error reading "100000": Math result not representable
::::::::::::::
int4.out.dif
::::::::::::::
10c10
< ERROR: pg_atoi: error reading "1000000000000": Result too large
---
> ERROR: pg_atoi: error reading "1000000000000": Math result not representable
::::::::::::::
run_ruletest.out.dif
::::::::::::::
230d229
< jwieck|notjw
231a231
> jwieck|notjw
256,262c256,262
< ename |who |action |newsal |oldsal
< --------------------+--------+----------+----------+----------
< wiech |postgres|hired |$5,000.00 |$0.00
< gates |postgres|hired |$80,000.00|$0.00
< wieck |postgres|honored |$6,000.00 |$5,000.00
< wieck |postgres|honored |$7,000.00 |$6,000.00
< gates |postgres|fired |$0.00 |$80,000.00
---
> ename |who |action |newsal |oldsal
> --------------------+-----+----------+----------+----------
> wiech |pgsql|hired |$5,000.00 |$0.00
> gates |pgsql|hired |$80,000.00|$0.00
> wieck |pgsql|honored |$6,000.00 |$5,000.00
> wieck |pgsql|honored |$7,000.00 |$6,000.00
> gates |pgsql|fired |$0.00 |$80,000.00
270,279c270,279
< ename |who |action |newsal |oldsal
< --------------------+--------+----------+----------+----------
< wiech |postgres|hired |$5,000.00 |$0.00
< gates |postgres|hired |$80,000.00|$0.00
< wieck |postgres|honored |$6,000.00 |$5,000.00
< wieck |postgres|honored |$7,000.00 |$6,000.00
< gates |postgres|fired |$0.00 |$80,000.00
< meyer |postgres|hired |$4,000.00 |$0.00
< maier |postgres|hired |$5,000.00 |$0.00
< mayr |postgres|hired |$6,000.00 |$0.00
---
> ename |who |action |newsal |oldsal
> --------------------+-----+----------+----------+----------
> wiech |pgsql|hired |$5,000.00 |$0.00
> gates |pgsql|hired |$80,000.00|$0.00
> wieck |pgsql|honored |$6,000.00 |$5,000.00
> wieck |pgsql|honored |$7,000.00 |$6,000.00
> gates |pgsql|fired |$0.00 |$80,000.00
> meyer |pgsql|hired |$4,000.00 |$0.00
> maier |pgsql|hired |$5,000.00 |$0.00
> mayr |pgsql|hired |$6,000.00 |$0.00
285,297c285,297
< ename |who |action |newsal |oldsal
< --------------------+--------+----------+----------+----------
< wiech |postgres|hired |$5,000.00 |$0.00
< gates |postgres|hired |$80,000.00|$0.00
< wieck |postgres|honored |$6,000.00 |$5,000.00
< wieck |postgres|honored |$7,000.00 |$6,000.00
< gates |postgres|fired |$0.00 |$80,000.00
< meyer |postgres|hired |$4,000.00 |$0.00
< maier |postgres|hired |$5,000.00 |$0.00
< mayr |postgres|hired |$6,000.00 |$0.00
< maier |postgres|honored |$6,000.00 |$5,000.00
< mayr |postgres|honored |$7,000.00 |$6,000.00
< meyer |postgres|honored |$5,000.00 |$4,000.00
---
> ename |who |action |newsal |oldsal
> --------------------+-----+----------+----------+----------
> wiech |pgsql|hired |$5,000.00 |$0.00
> gates |pgsql|hired |$80,000.00|$0.00
> wieck |pgsql|honored |$6,000.00 |$5,000.00
> wieck |pgsql|honored |$7,000.00 |$6,000.00
> gates |pgsql|fired |$0.00 |$80,000.00
> meyer |pgsql|hired |$4,000.00 |$0.00
> maier |pgsql|hired |$5,000.00 |$0.00
> mayr |pgsql|hired |$6,000.00 |$0.00
> maier |pgsql|honored |$6,000.00 |$5,000.00
> mayr |pgsql|honored |$7,000.00 |$6,000.00
> meyer |pgsql|honored |$5,000.00 |$4,000.00
302,317c302,317
< ename |who |action |newsal |oldsal
< --------------------+--------+----------+----------+----------
< wiech |postgres|hired |$5,000.00 |$0.00
< gates |postgres|hired |$80,000.00|$0.00
< wieck |postgres|honored |$6,000.00 |$5,000.00
< wieck |postgres|honored |$7,000.00 |$6,000.00
< gates |postgres|fired |$0.00 |$80,000.00
< meyer |postgres|hired |$4,000.00 |$0.00
< maier |postgres|hired |$5,000.00 |$0.00
< mayr |postgres|hired |$6,000.00 |$0.00
< maier |postgres|honored |$6,000.00 |$5,000.00
< mayr |postgres|honored |$7,000.00 |$6,000.00
< meyer |postgres|honored |$5,000.00 |$4,000.00
< maier |postgres|fired |$0.00 |$6,000.00
< mayr |postgres|fired |$0.00 |$7,000.00
< meyer |postgres|fired |$0.00 |$5,000.00
---
> ename |who |action |newsal |oldsal
> --------------------+-----+----------+----------+----------
> wiech |pgsql|hired |$5,000.00 |$0.00
> gates |pgsql|hired |$80,000.00|$0.00
> wieck |pgsql|honored |$6,000.00 |$5,000.00
> wieck |pgsql|honored |$7,000.00 |$6,000.00
> gates |pgsql|fired |$0.00 |$80,000.00
> meyer |pgsql|hired |$4,000.00 |$0.00
> maier |pgsql|hired |$5,000.00 |$0.00
> mayr |pgsql|hired |$6,000.00 |$0.00
> maier |pgsql|honored |$6,000.00 |$5,000.00
> mayr |pgsql|honored |$7,000.00 |$6,000.00
> meyer |pgsql|honored |$5,000.00 |$4,000.00
> maier |pgsql|fired |$0.00 |$6,000.00
> mayr |pgsql|fired |$0.00 |$7,000.00
> meyer |pgsql|fired |$0.00 |$5,000.00
::::::::::::::
tinterval.out.dif
::::::::::::::
22c22
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
---
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
41c41
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
---
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
66c66
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
---
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
76c76
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
---
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
101c101
< |["Thu Feb 15 12:15:03 1990 PST" "current"] |["Thu Feb 15 12:15:03 1990 PST" "current"]
---
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"]
104c104
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14
03:14:211973 PST"]
---
> |["Thu Feb 15 12:15:03 1990 PST" "current"] |["Thu Feb 15 12:15:03 1990 PST" "current"]
112a113,114
> |["-infinity" "infinity"] |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"]
> |["-infinity" "infinity"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"]
115,117c117
< |["-infinity" "infinity"] |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14
03:14:211973 PST"]
< |["-infinity" "infinity"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"]
< |["Thu Feb 15 12:15:03 1990 PST" "current"] |["-infinity" "infinity"]
---
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]
119,122c119,122
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]
< |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14
03:14:211973 PST"]
< |["Thu Feb 15 12:15:03 1990 PST" "current"] |["epoch" "Mon May 01 00:30:30 1995 PDT"]
---
> |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]
> |["Thu Feb 15 12:15:03 1990 PST" "current"] |["-infinity" "infinity"]
> |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"]
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
126c126
< |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]
---
> |["Thu Feb 15 12:15:03 1990 PST" "current"] |["epoch" "Mon May 01 00:30:30 1995 PDT"]
136c136
< |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]
---
> |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
+------------------------------------------+------------------------------+
| Robert E. Bruccoleri, Ph.D. | Associate Research Professor |
| phone: 732 235 5796 | Center for Advanced |
| Fax: 732 235 4850 | Biotechnology and Medicine |
| email: bruc@acm.org | Rutgers University |
| URL: http://www.cabm.rutgers.edu/~bruc | 679 Hoes Lane |
| | Piscataway, NJ 08854-5638 |
+------------------------------------------+------------------------------+
pgsql-hackers by date: