Forum OpenACS Q&A: Error installing OpenACS with PostgreSQL 8.1

Collapse
1: Error installing OpenACS with PostgreSQL 8.1
Posted by Ricardo Jorge on 08/17/06 11:56 PM
I know I can run OpenACS + PostgreSQL 8.1 if I preload my PG 8.1 database with data from a previous installation, but now I want to make an installation from "scratch".

The error I have is on utilities-create.sql, and it shows:

psql:utilities-create.sql:29: ERROR: syntax error at or near "".nextval as a_seq_val"" at character 40
QUERY: SELECT "select " || quote_ident( $1 ) ".nextval as a_seq_val"
CONTEXT: SQL statement in PL/PgSQL function "util__multiple_nextval" near line 8
psql:utilities-create.sql:29: LINE 1: SELECT "select " || quote_ident( $1 ) ".nextval as a_seq_va...
psql:utilities-create.sql:29: ^
CREATE FUNCTION

I've follow PG configuration from this message https://openacs.org/forums/message-view?message_id=404776

My system is OpenSuSE 10.1 + PG 8.1.4 and I am trying to install OpenACS 5.2.3.

On the same computer I am running ]project-open[ and OpenACS 5.2 (that I've installed on another computer and back-up the database to this one).

Anyone can help ? Thanks... Ricardo Jorge

Collapse
2: Re: Error installing OpenACS with PostgreSQL 8.1 (response to 1)
Posted by Rocael Hernández Rizzardini on 08/18/06 04:41 AM
that function was fixed in HEAD, so you either substitute that with the one of head, or just comment it, since is not used anyway in any place.
Collapse
3: Re: Error installing OpenACS with PostgreSQL 8.1 (response to 2)
Posted by Ricardo Jorge on 08/18/06 04:22 PM
I commented out the entire function and the installation proceed without errors. Thank you ...