Forum OpenACS Q&A: Response to OpenACS on Win2k: again..

Posted by C. R. Oldham on
I'm trying to load the data model for OpenACS 3.2.5 on pg 7.1.1 under Win2k.  This is the latest postgresql from the cygwin distribution.  The following statement from homepage.sql is making the postgres backend terminate with status 139:

select hp_get_filesystem_root_node(1);

This seems to indicate there is some problem with the plpgsql function, but there doesn't appear to be anything wrong with it.  I tried commenting it out, but at the end of survsimp.sql there is this statement:

select administration_group_add ('Simple Survey System Staff', short_name_from_group_name('survsimp'), 'survsimp', '', 'f', '/survsimp/admin/');

And I discovered that 'select short_name_from_group_name('survsimp')' also will cause the backend to fail.

Has anyone seen this?