Re: [PORTS] Compiling PostgreSQL 8.1.5 with 64-bit on a G5 SOLVED

On 27-Nov-06, at 6:17 PM, Tom Lane wrote:
> Brian Wipf <[email protected]> writes:
>> I applied that patch to s_lock.h in our PostgreSQL 8.1.5 source, and
>> the 64-bit compile went through without a hitch.
>
> Does it pass "make check"?

Umm, no. Maybe we should wait for 8.2 before going 64-bit in production?

test create_function_1    ... FAILED
...
      triggers             ... FAILED
...

=======================
2 of 98 tests failed.
=======================

start of regression.out:

*** ./expected/create_function_1.out    Tue Nov 28 01:20:45 2006
--- ./results/create_function_1.out     Tue Nov 28 01:21:16 2006
***************
*** 27,40 ****
--- 27,43 ----
         RETURNS trigger
         AS '/Users/admin/Downloads/postgresql-8.1.5/src/test/ 
regress/../../../contrib/spi/refint.so'
         LANGUAGE 'C';
+ ERROR:  could not load library "/Users/admin/Downloads/ 
postgresql-8.1.5/src/test/regress/../../../contrib/spi/refint.so":  
inappropriate object file
   CREATE FUNCTION check_foreign_key ()
         RETURNS trigger
         AS '/Users/admin/Downloads/postgresql-8.1.5/src/test/ 
regress/../../../contrib/spi/refint.so'
         LANGUAGE 'C';
+ ERROR:  could not load library "/Users/admin/Downloads/ 
postgresql-8.1.5/src/test/regress/../../../contrib/spi/refint.so":  
inappropriate object file
   CREATE FUNCTION autoinc ()
         RETURNS trigger
         AS '/Users/admin/Downloads/postgresql-8.1.5/src/test/ 
regress/../../../contrib/spi/autoinc.so'
         LANGUAGE 'C';
+ ERROR:  could not load library "/Users/admin/Downloads/ 
postgresql-8.1.5/src/test/regress/../../../contrib/spi/autoinc.so":  
inappropriate object file
   CREATE FUNCTION funny_dup17 ()
           RETURNS trigger
           AS '/Users/admin/Downloads/postgresql-8.1.5/src/test/ 
regress/regress.so'

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

*** ./expected/triggers.out     Tue Aug 30 19:57:48 2005
--- ./results/triggers.out      Tue Nov 28 01:21:19 2006
***************
*** 24,33 ****
--- 24,35 ----
         for each row
         execute procedure
         check_primary_key ('fkey1', 'fkey2', 'pkeys', 'pkey1',  
'pkey2');
+ ERROR:  function check_primary_key() does not exist
...


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster