Forum OpenACS Q&A: Response to Howto move Postgres database

when you look at the creation code of the tree_ancestor things you will notice that some they are created by dynamically written queries. (I think this is because they both call the other or something funny like that) So you need to create these two functions manually after restoring the dump. In my experience, this was the only problem moving a db like that, i did it a few times.

ciao,