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