On Sat, Dec 19, 2009 at 7:08 PM, Postgres User <postgres.developer@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
