Forum OpenACS Q&A: OpenACS 3.2.4 and PostgreSQL 7.1beta4

Collapse
1: OpenACS 3.2.4 and PostgreSQL 7.1beta4
Posted by Krzysztof Kowalczyk on 02/03/01 09:19 AM
If anyone is installing OpenACS with PostgreSQL 7.1beta4 installed from rpms, the www/doc/sql/postgres.sql needs to be adjusted a bit: 
create function plpgsql_call_handler() RETURNS opaque
as '/usr/lib/pgsql/plpgsql.so' language 'c';
should be 
create function plpgsql_call_handler() RETURNS opaque
as '/usr/lib/plpgsql.so' language 'c';
Otherwise the datamodel creation will fail. The location of plpgsql.so has changed wrt to 7.0.2. I don't know if it's only 7.1beta4 glitch or if it'll be like that in 7.1 final.

Also in bookmarks.sql this function should be commented out: 

create function chr(int4)
returns char
as '
begin
   return ichar($1);
end;'
language 'plpgsql';
as 7.1 comes with it. I don't know if semantics are the same, though.
Collapse
2: Response to OpenACS 3.2.4 and PostgreSQL 7.1beta4 (response to 1)
Posted by Don Baccus on 02/03/01 05:28 PM
I hadn't noticed that because I usually create plpgsql via
"createlang" when I create the database, and ignore the "already
defined" error message when I load the datamodel.  Thanks for catching
this.

chr() just gives a dupe function error, right?  The new built-in works
just fine, we need to leave ours in for PG 7.0 users.  We should
probably just document the fact that the dupe error can be ignored.

Roberto, are you available to add a short "notes for PG 7.1" section?

Collapse
3: Response to OpenACS 3.2.4 and PostgreSQL 7.1beta4 (response to 1)
Posted by Roberto Mello on 02/04/01 03:17 AM
Don,
Sure. I'll do that this week, along with some minor corrections here and there. Thanks for reminding me. If you'd like to e-mail me with any other changes worthy of showing up on the notes, that'd be great too.
Collapse
4: Response to OpenACS 3.2.4 and PostgreSQL 7.1beta4 (response to 1)
Posted by Don Baccus on 02/04/01 03:45 AM
Roberto - maybe you could write a bit about using the Great Bridge
pgsql installer, too? (see the other thread from earlier today)
Collapse
5: Response to OpenACS 3.2.4 and PostgreSQL 7.1beta4 (response to 1)
Posted by Lamar Owen on 02/05/01 07:36 PM
It is a beta4 RPM glitch.  The final resting place for plpgsql.so and friends for the RPM will be /usr/lib/pgsql, which will also contain other goodies.....
Collapse
6: Response to OpenACS 3.2.4 and PostgreSQL 7.1beta4 (response to 1)
Posted by Roberto Mello on 02/15/01 02:48 AM
I am updating the documentation right now. Is there anything else I should include in the "PG 7.1 Notes" section?