Re: 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 <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
...