On Sat, Dec 19, 2009 at 7:08 PM, Postgres User <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
