On Sat, Dec 19, 2009 at 7:08 PM, Postgres User
<postgres.developer@gmail.com> wrote:
> Great call, someone did hose the data. Oddly enough the circular
> reference caused no problem when running the stand alone recursive SQL
> (with clause).
>
no problem. I would advise guarding against circular dependencies
either with a trigger on the relationship table, a recursion limit in
the query itself, or both.
merlin