Forum OpenACS Q&A: OACS with Postgresql 8

Collapse
1: OACS with Postgresql 8
Posted by Sam Nicholson on 06/05/05 01:32 AM
Any hope of getting Oacs 5.1.5 to work with Postgresql 8?
I've so much that depends upon postgresql 8. I'd rather not
run two databases.

Can I just grab the packages/acs-kernel/postgres directory
from cvs, or is it more than that?

thanks
-sam

Collapse
2: Re: OACS with Postgresql 8 (response to 1)
Posted by Sam Nicholson on 06/09/05 03:31 PM
Yeah, it's a lot more than that...

I'm new to ACS, but from the errors that issue,
the sql code in 5.1.5 is absent typing. I've
cvs the HEAD and things seem to have been updated
to work with PG 8.

Collapse
3: Re: OACS with Postgresql 8 (response to 1)
Posted by Don Baccus on 06/11/05 10:48 PM
The changes were quite easy and should be possible to backport to 5.1.5 if you need to ...

Or you can wait until we release 5.2 ...

Collapse
4: Re: OACS with Postgresql 8 (response to 1)
Posted by Dario Roig on 02/17/06 10:06 AM
Hi!

We are testing the OACS-5-1 withw PosgreSQL 8.1.

-The first step is do dump 7.4.x and restore on 8.1
-The second is solve the problem with function bit

Someone to solved the problem?

Thanks.

Collapse
5: Re: Res: OACS with Postgresql 8 (response to 1)
Posted by Dario Roig on 02/17/06 11:34 AM
Code for solve problem with function bit in PostgreSQL 8

create or replace function bitfromint4 (integer)
returns bit varying as '
begin
return $1::bit(32);
end;' language 'plpgsql' immutable strict;
Collapse
6: Re: OACS with Postgresql 8 (response to 1)
Posted by Matthew Dodwell on 02/17/06 04:40 PM
Does this mean that 8.1 will now work, as opposed to 8.0? (I'm running 8.0.4)

cheers
Matthew