Forum OpenACS Q&A: Response to Installing OpenACS with PostgreSQL

Collapse
Posted by Don Baccus on
I personally think we need to support PG 7.1 and Oracle 8.1.6 for
the first half of 2002, anyway.  There's nothing in PG 7.2 or Oracle
9i that's necessary.

Now ... PG 7.2 would've made porting slightly easier (create or
replace exists) and 9i with its support of SQL92 outer join syntax
means we could've used generic db-independent SQL for those queries,
easing our long-term maintenance problems.

But .. that's water under the brdge, we've already ported our asses
off.

And there's nothing in these new versions that have the impact on
our work that the addition of outer joins to PG 7.1 had.  That was a
lifesaver.  The improvements in PG 7.2 and Oracle 9i are relatively
minor from the generic toolkit point of view (individual site
builders may find things that will really help them, of course, and
PG 7.2's "lazy vacuum" will be welcomed by people running really
busy PG-based sites).