From: Andreas <maps.on@gmx.net>
To: Gurjeet Singh <singh.gurjeet@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to cascade information like the user roles ?
Date: Wed, 20 Jan 2010 17:43:12 +0100
Message-ID: <4B5732A0.1090006@gmx.net> (raw)
In-Reply-To: <65937bea1001192223o2a443c3dw9148352fc2bb76d4@mail.gmail.com>
References: <4B54FDF3.4070601@gmx.net>
<92869e661001190627i4d42e368nbb0e96bf5c54ca76@mail.gmail.com>
<4B55E22F.80409@gmx.net>
<65937bea1001192145u380846f3u30cc10d9d1784690@mail.gmail.com>
<65937bea1001192223o2a443c3dw9148352fc2bb76d4@mail.gmail.com>
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 :)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net, singh.gurjeet@gmail.com
Subject: Re: How to cascade information like the user roles ?
In-Reply-To: <4B5732A0.1090006@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox