Regress test failing on Sparc Solaris 2.5.1 - Mailing list pgsql-general

From Anand Surelia
Subject Regress test failing on Sparc Solaris 2.5.1
Date
Msg-id 369130D5.A0CC1B60@bytekinc.com
Whole thread Raw
List pgsql-general
I've successfully installed v6.4.2 on my Sparc Solaris 2.5.1, however
it's failing a lot of regression tests, specifically:
1. int8 .... probably my machine or compiler may not support it.
2. geometry... only minor floating point differences
3. abstime... this was strange. I am attaching the relevant lines from
regression.diff
*** expected/abstime.out        Sun Jan  4 19:35:19 1998
--- results/abstime.out Mon Jan  4 12:16:12 1999
***************
*** 22,28 ****
       |current
       |infinity
       |-infinity
!      |Sat May 10 23:59:12 1947 PST
       |invalid
  (8 rows)

--- 22,28 ----
       |current
       |infinity
       |-infinity
!      |Sun May 11 00:59:12 1947 PDT
       |invalid
  (8 rows)
Probably due to the change in the timezone.
4. tinterval and  horology for the same reasons as above.
5. create_function_2, trigger, misc, plpgsql all fail because the shared
objects libraries are failing to load. These are the messages I get in
regress.log
Load of file /bytek/postgres/postgresql-6.4.2/src/test/regress/input/.
./regress.so failed: ld.so.1: /bytek/postgres/bin/postmaster: fatal:
relocation
error: symbol not found: SPI_tuptable: referenced in
/bytek/postgres/postgresql-
6.4.2/src/test/regress/input/../regress.so

Load of file /bytek/postgres/postgresql-6.4.2/src/test/regress/input/.
./../../../contrib/spi/refint.so failed: ld.so.1:
/bytek/postgres/bin/postmaster
: fatal: relocation error: symbol not found: SPI_result: referenced in
/bytek/po
stgres/postgresql-6.4.2/src/test/regress/input/../../../../contrib/spi/refint.so

Load of file /bytek/postgres/postgresql-6.4.2/src/test/regress/input/.
./../../../contrib/spi/autoinc.so failed: ld.so.1:
/bytek/postgres/bin/postmaste
r: fatal: relocation error: symbol not found: SPI_result: referenced in
/bytek/p
ostgres/postgresql-6.4.2/src/test/regress/input/../../../../contrib/spi/autoinc.

so

 Load of file /bytek/postgres/lib/plpgsql.so failed: ld.so.1: /bytek/po
stgres/bin/postmaster: fatal: relocation error: symbol not found:
SPI_tuptable:
referenced in /bytek/postgres/lib/plpgsql.so

Is it normal to fail these regressioin tests? Also, has the SPI
interface been changed because I remember something being talked about
that on this maling list. Would I have to change all my triggers from
SPI to PL/PGSQL ( or whatever its called)?

Thanks for your time,

- Anand Surelia.


pgsql-general by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] 88, CREATE FUNCTION ON TABLE
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] Subselect question