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

[Brian Wipf <brian(at)clickspace(dot)com>]

On 27-Nov-06, at 6:17 PM, Tom Lane wrote:
> Brian Wipf <brian(at)clickspace(dot)com> 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
...