Forum OpenACS Q&A: PG 7.3.2 not working with OpenACS 4.6.1 yet?

I'm having difficulty getting OpenACS 4.6.1 (beta) to work with PG 7.3.2. This thread suggests that OpenACS 4.6.1 was to work with PG 7.3.2 (well the thread was back in February). This thread is meant as a heads-up for those thinking of using PG 7.3.2, I'm planning to move back to PG 7.2.4. The (first) error message is:
[10/Mar/2003:22:51:00][11042.3076][-conn0-] Error: db_source_sql_file: acs-kernel-create.sql:
psql:groups-body-create.sql:220: ERROR:  ProcedureCreate: cannot change return type of existing function.
	Use DROP FUNCTION first.
psql:acs-create.sql:303: ERROR:  -20000: Insert to composition rels not yet supported
(I have also fixed an error I had been struggling with that manifested itself as "[09/Mar/2003:19:49:44][1160.7176][-conn4-] Error: return: failed to redirect '404': exceeded recursion limit of 3" errors. The parent directory [/home/michael] was unreadable [drwx------] to the webserver user [sitename], and needed chmoding)
Collapse
Posted by Don Baccus on
4.6.2 will support PG 7.3.2.  The CVS branch tagged oacs-4-6 should stabilize in the next week or so - we're aiming for a Friday code freeze but it may be more like sometime next week.
Collapse
Posted by Michael Bluett on
Thanks for the response Don. I probably should have looked at a previous message of yours ("PG 7.3 support won't be in for 4.6 or 4.6.1"). The project status page suggested that PG 7.3.1 would be supported in 4.6.1 ("will also include support for Postgres 7.3.1"). It sounds like 4.6.1 had all of the goodies (performance issues) and 4.6.2 is just for PG 7.3.2 and maybe 9i.
Collapse
Posted by Don Baccus on
I fixed the project page ... sorry about that!