Problems getting a usable pgsql 6.4 on irix 6.3

From: "Ben S(dot)" <bliss(at)e-e(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Problems getting a usable pgsql 6.4 on irix 6.3
Date: 1998-11-25 19:21:56
Message-ID: 199811251921.NAA19320@albert.e-e.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

First, of course, thanks for all the work on postgresql.

I've been using 6.3 on two SGI O2's (irix 6.3) for a about six
months. I tried to make 6.4, and came across bunches of errors,
not in the build, but in making a new database on it, and running
the regression tests.

Like 6.3, I fixed up backend/Makefile, and compiled with CC -n32 and
LD -n32. When I try make a simple view (which worked on 6.3) I get
"ERROR: cannot create v_story_info". The select query, entered
as just query, does work.

create view
v_story_info as select
stories.story_id, is_current, pub_date,
size, paper_page, grouping_id,
slug, headline, subhead,
dateline, series.series_id, series_name,
ed_note, correction, summary
from
stories, series, story_attrib
where
story_attrib.story_id = stories.story_id and
series.series_id = stories.grouping_id
;

I think there are several other errors in the regression tests,
but I'm still sorting through which errors are trivial. The SELECT
DISTINCT seems to fetch no rows. If there's no other volunteer,
I'll make an output file for the distribution, if I can get postgres
working. :)

Thanks for any help, or any places to start looking for a cure.
Ben

Here is some of the regression output:

*** expected/create_type.out Tue Apr 22 12:33:34 1997
--- results/create_type.out Wed Nov 25 01:25:56 1998
***************
*** 4,9 ****
--- 4,10 ----
output = widget_out,
alignment = double
);
+ ERROR: TypeCreate: function 'widget_in(opaque)' does not exist
QUERY: CREATE TYPE city_budget (
internallength = 16,
input = int44in,

for each row
execute procedure
check_primary_key ('fkey1', 'fkey2', 'pkeys', 'pkey1', 'pkey2');
+ ERROR: CreateTrigger: function check_primary_key () does not exist

+ ERROR: CreateTrigger: function funny_dup17 () does not exist

*** expected/create_view.out Sun Apr 6 00:05:32 1997
--- results/create_view.out Wed Nov 25 01:26:24 1998
***************
*** 7,12 ****
--- 7,13 ----
interpt_pp(ih.thepath, r.thepath) AS exit
FROM ihighway ih, ramp r
WHERE ih.thepath ## r.thepath;
+ ERROR: No such function 'interpt_pp' with the specified attributes
QUERY: CREATE VIEW toyemp AS
SELECT name, age, location, 12*salary AS annualsal
FROM emp;

In results/select.out, one of many:
QUERY: SELECT onek.unique1, onek.stringu1
WHERE onek.unique1 < 20
ORDER BY unique1 using >;
unique1|stringu1
-------+--------
! (0 rows)

Browse pgsql-hackers by date

  From Date Subject
Next Message Henry B. Hotz 1998-11-25 20:32:08 Testing, Hello?
Previous Message Terry Mackintosh 1998-11-25 18:09:55 Re: [HACKERS] pg_dump(all) and views, broke