Re: How to cascade information like the user roles ?
| От | Andreas |
|---|---|
| Тема | Re: How to cascade information like the user roles ? |
| Дата | |
| Msg-id | 4B5732A0.1090006@gmx.net обсуждение исходный текст |
| Ответ на | Re: How to cascade information like the user roles ? (Gurjeet Singh <singh.gurjeet@gmail.com>) |
| Ответы |
Re: How to cascade information like the user roles ?
|
| Список | pgsql-sql |
Thanks a whole lot and some :) It's great that you actually did a working script. I find it tremendosly easier to learn with a working example than with some links to other documentation which makes or does not make sense. I've got a 8.4 server so both ways work nicely. Is there a way to prevent inheritance loops instead of denying parent_id > child_id ? Parallel inheritance has to work, though. 1 <-- 2 and 3 <-- 4 I found the function running into a stack overflow when I intetionally created a loop to check what'll happen. At least this is a predefined limit in max_stack_depth. The with recursive thingy just kept going which generally tends to be worse, I guess. Regards :)
В списке pgsql-sql по дате отправления: