On Mon, May 05, 2003 at 11:05:41AM +0200, Ralph Graulich wrote:
> It took me a whole three days to rearrange about nearly 1.400 database
> objects, couting sequences, triggers, tables, views, rules and pl/pgsql
> procedures. So, one thing I learned: Before extending my project, first
> accomplish a working upgrade path by writing down all dependencies ;-)
I wonder if it would be possible to create script that would take a guess at
all the dependancies, feed that to tsort and somehow get pg_restore to
restore the DB in the right order.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington