Forum OpenACS Q&A: Problems with initial load of tables

As suggested I did

psql -f load-data-model.sql [my database name] 2> datamodel.txt

during the instalation process.

(Linux RedHat 6.2, PostgreSQL 6.5.3 RPM from the CD)
OpenACS 3.2.4

Unfortunately I got quite a few "ERROR" messages. Most things worked
but I ended up with things like

-- drop function sign(interval);
create function sign(interval) returns integer as '
declare
    the_interval alias for $1;
begin
    if date_part(''day'',the_interval) >=0 then return 1;
    else return -1;
    end if;
end;
' language 'plpgsql';
ERROR:  parser: parse error at or near "interval"

AND

create view users_spammable
as
select u.*, up.email_type
from users u, users_preferences up
where u.user_id = up.user_id
and user_state = 'authorized'
and (email_bouncing_p is null or email_bouncing_p = 'f')
and (dont_spam_me_p is null or dont_spam_me_p = 'f')
and user_vacations_kludge(u.user_id) = 0;
ERROR:  DefineQueryRewrite: rule plan string too big.

If you want to hel pme out with this the whole output is at
http://www.arcfan.demon.co.uk/datamodel1.txt

Feel free to point me in the direction of the appropriate
documentation if I have missed it.

One of the problems is the lztext thing which I believe is
supposed to not work, no?

Thanks

Alex McLintock

Collapse
Posted by Don Baccus on
OpenACS requires PG 7.0, not PG 6.5.  Preferably PG 7.0.3 (which has
quite a few bug fixes compared to PG 7.0.0).

This requirement's spelled out in the install docs but is easy to miss.

You can pick up PG 7.0.3 from http://www.postgresql.org.