This is a real pain. Especially if you don't know why is this happening. It puts OpenACS in a bad position of not being a restorable system. Although this is not postgres specific I believe. In ACS 3.4.10 I get 3 broken views using export and import of Oracle
Can we have backup and restore as part of testing? I think its very important. Also maybe some body is kind enough to place in the docs a "How to backup and restore OpenACS sites". Maybe this should include some explanation of the content-repository-content-files dir. That this dir needs to be restored too. This would help a lot of new users.
