Forum OpenACS Q&A: PostGres Start With/Connect By Clause

Collapse
1: PostGres Start With/Connect By Clause
Posted by Medha Vyas on 07/14/04 01:15 PM
Can someone please help me with the postgres equivalent of Start With/ Connect By Claued which is found in oracle?
Collapse
2: Re: PostGres Start With/Connect By Clause (response to 1)
Posted by Jarkko Laine on 07/14/04 01:28 PM
Medha,

Sure, in OpenACS we use tree_sortkey. See Jade's article for more info.

Collapse
3: Re: PostGres Start With/Connect By Clause (response to 1)
Posted by Jarkko Laine on 07/14/04 01:37 PM
This should be a more recent version of the same article.
Collapse
4: Re: PostGres Start With/Connect By Clause (response to 2)
Posted by Medha Vyas on 07/14/04 01:48 PM
Thank you Sir
Collapse
5: Re: PostGres Start With/Connect By Clause (response to 1)
Posted by Dave Manginelli on 07/14/04 02:40 PM
The context_id field referenced in the article was originally meant for use in defining _permissions inheritance only_.  The article calls past use of the field "ambiguous."  Could someone in-the-know please elaborate on the current best practices with regard to context_id???
Collapse
6: Re: PostGres Start With/Connect By Clause (response to 1)
Posted by Dave Bauer on 07/14/04 03:06 PM
Context_id is only for permissions inherietance.

Jeff Davis and I have discuessed morphing the "package_id" column in acs_objects on OpenACS 5.2 to "parent_id". In most cases it would end up being the package_id, but it would allow a real object hierarchy.

Collapse
7: Re: PostGres Start With/Connect By Clause (response to 1)
Posted by Jade Rubick on 07/14/04 09:17 PM
But until 5.2 comes out, you don't have much choice about using the context_id unless you are using the content repository.

So that's why I call it ambiguous. It has been used for more than just permissions inheritance.

Collapse
8: Re: PostGres Start With/Connect By Clause (response to 1)
Posted by Dave Bauer on 07/14/04 09:32 PM
Jade,

What do you mean you don't have a choice? What choice is there to make regarding context_id?