Forum OpenACS Development: PL/pgSQL concurrency and tree_sortkey questions
Hm, is that concurrency problem related to the race condition Patrick M. was talking about back in Feb. 2003? (Which was fixed since then, I hope?)
Also, a basic OpenACS data model tutorial question: In the Postgres version the acs_objects table has this tree_sortkey column, while the Oracle version appears to have no equivalent column. Why? Does the Oracle version just use a connect by on the context_id column somewhere, while for Postgres the tree_sortkey provides the same information? Or something completely different? (This had probably been answered several times elsewhere, but if so I couldn't find it...)
Yes, most of the oracle datamodel uses connect by for this rather than tree_sortkey but they are roughly equivalent. The tree_sortkey stuff has been implemented in oracle is used in dotlrn (for the dotlrn_communities_all and dotlrn_community_types tables). My gut tells me tree_sortkey is a better answer for heirarchies that are mostly static but I am not aware of anyone having benchmarked things.