YESSS, it seems to work now!!!
Thank you very very much!!! (of course everyone who tried to help)
only one thing:
regression test fails at 2 points
abstime ... FAILED
random ... failed (ignored)
the regression.diffs file looks:
*** ./expected/abstime-solaris-1947.out Thu May 3 21:00:37 2001
--- ./results/abstime.out Sun Aug 26 18:03:49 2001
***************
*** 47,56 ****
| Sun Jan 14 03:14:21 1973 PST
| Mon May 01 00:30:30 1995 PDT
| epoch
- | current
| -infinity
| Sat May 10 23:59:12 1947 PDT
! (6 rows)
SELECT '' AS six, ABSTIME_TBL.*
WHERE ABSTIME_TBL.f1 > abstime '-infinity';
--- 47,55 ----
| Sun Jan 14 03:14:21 1973 PST
| Mon May 01 00:30:30 1995 PDT
| epoch
| -infinity
| Sat May 10 23:59:12 1947 PDT
! (5 rows)
SELECT '' AS six, ABSTIME_TBL.*
WHERE ABSTIME_TBL.f1 > abstime '-infinity';
======================================================================
*** ./expected/random.out Thu Jan 6 07:40:54 2000
--- ./results/random.out Sun Aug 26 18:05:12 2001
***************
*** 31,35 ****
WHERE random NOT BETWEEN 80 AND 120;
random
--------
! (0 rows)
--- 31,36 ----
WHERE random NOT BETWEEN 80 AND 120;
random
--------
! 127
! (1 row)
#######################################
What does it mean? CURRENT_TIMESTAMP and CURRENT_DATE seem to produce the expected
results.
thanks again, Peter
Justin Clift <[EMAIL PROTECTED]> wrote:
> Hi Peter,
>
> There's a Solaris specific installation guide for PostgreSQL at :
>
> http://techdocs.postgresql.org/installguides.php#solaris
>
> Have you taken a look at it yet?
>
> Regards and best wishes,
>
> Justin Clift
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
