Forum OpenACS Q&A: PostgreSQL v7.2 && openacs 3.2.5 ????

Hi, I would like to know if openacs 3.2.5 will have any kind of
problems working with pg 7.2

Or, it's ok and I should install in my new machine pg7.2 and work as
usual without worring about anything.

If yes, install pg 7.2, is there some special steps to go into in
order to succesfully install openacs 3.2.5?

Collapse
Posted by Don Baccus on
One problem has been reported, AFAIK none other.  (the problem's in a char() cast that should be varchar()) Try it and report back to us?  And help us fix any problems?  That seems the most democratic approach for the community.
ok, I'll do it!, as soon as I get my new machine!!
Collapse
Posted by Paul Doerwald on

The particular issue is in www/doc/sql/security.sql. In the function sec_rotate_last_visit (integer, integer), change the last line which currently reads values(v_browser_id, ''acs'', ''last_visit'', v_time::char, ''f''); to values(v_browser_id, ''acs'', ''last_visit'', v_time::varchar, ''f'');

Everything will work just fine then.

Collapse
Posted by Paul Doerwald on

I've submitted it to the SDM: https://openacs.org/sdm/one-baf.tcl?baf_id=1341.

Too bad I didn't do it right (submitted a patch in the description...)

Thanks Paul, so then we just need to proceed with the normal installation I supose.

=)