Forum OpenACS Q&A: Re: xql files and db version
We could break out query files by version - that's why we implemented that level of granularity in the query dispatcher.
But in practice thus far we've been able to do our version migrations without doing so. With PG we've tried to support the current and current-less-one major version - at the moment PG 7.2.x and 7.3.x. OpenACS 5.0 will support Oracle 9i and 8i, and PG 7.2/7.3 (PG 7.4 is still in beta).