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.