Message-ID: <4B5732A0.1090006@gmx.net>
Date: Wed, 20 Jan 2010 17:43:12 +0100
From: Andreas <maps.on@gmx.net>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: Gurjeet Singh <singh.gurjeet@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: How to cascade information like the user roles ?
References: <4B54FDF3.4070601@gmx.net>
	<92869e661001190627i4d42e368nbb0e96bf5c54ca76@mail.gmail.com>
	<4B55E22F.80409@gmx.net>
	<65937bea1001192145u380846f3u30cc10d9d1784690@mail.gmail.com>
	<65937bea1001192223o2a443c3dw9148352fc2bb76d4@mail.gmail.com>
In-Reply-To: <65937bea1001192223o2a443c3dw9148352fc2bb76d4@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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 :)