I encountered the same error running on SuSE 7.1 (kernel 2.4). This bboard pointed me to the real problem: Postgresql 7.1.1 is not working properly. Redid my installation with version 7.1.2. Everything worked fine. Before you actually load the datamodel I suggest you make an addition to homepage.sql. All the way at the end of the file, add:
--drop function hp_get_nh_member_count(integer); create function hp_get_nh_member_count(integer) returns integer as ' declare neighborhoodid alias for $1; counter integer; BEGIN select into counter count(*) from users_homepages where neighborhood_id = neighborhoodid; return counter; END; ' language 'plpgsql';And execute this create statement in psql. Otherwise the neighborhood functionality will not work.