Forum OpenACS Q&A: Re: Content repository with ACS5.0.2

Collapse
4: Re: Content repository with ACS5.0.2 (response to 1)
Posted by Don Baccus on 02/18/04 10:07 PM
In the Oracle version we use CONNECT BY to implement hierarchical queries.

PostgreSQL does not have an equivalent feature, so we added tree_sortkeys to acs_objects and certain other object types.  These sortkeys allow us to construct hierarchical queries in PostgreSQL.

You should study some of the hierarchical queries that exist in the Oracle version to figure out how to write your query correctly.  Be warned that CONNECT BY in 8i has some annoying and confusing restrictions (some of which have been removed in 9i).

Collapse
5: Re: Content repository with ACS5.0.2 (response to 4)
Posted by Jade Rubick on 02/18/04 10:20 PM
Don, is the context_id used to build the hierarchy in Oracle?

I'll put a note in the documentation (the advanced tutorial) that tree_sortkey is only in the Postgres version of acs_objects.

If you clarify this, I'll put it in the docs.