Re: pg_depend explained
Joel Jacobson <joel@gluefinance.com>
From: Joel Jacobson <joel@gluefinance.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Florian Pflug <fgp@phlo.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-01-12T17:33:31Z
Lists: pgsql-hackers
2011/1/12 Tom Lane <tgl@sss.pgh.pa.us>: > This isn't particularly *useful*, maybe, but it's hardly "impossible". > And if we analyzed function dependencies in any detail, circular > dependencies among functions would be possible (and useful). Thanks Tom for clarifying, this makes me even more motivated into implementing the "creation order"-algorithm using only sql/plpgsql and pg_depend. If you have any ideas on how to do this, in addition to reading the dependency.c and pg_dump_sort.c source code, they would be highly appreciated. Any tips on articles on graph algorithms which not only take edges (node->node) as indata, but also a "edge type" as indata (i.e. the deptype in pg_depend) would also be very useful. I have only found algorithms to do sorting on "normal" directional graphs, where all edges are threated the same. -- Best regards, Joel Jacobson Glue Finance