Hi all,
We've got postgresql 7.4 and a few views. I'm using pg_dump to backup the database and everything is ok. Recently, we added 5 new views - but when I restore the dump with psql, out of 5 new views, only 3 is recreated, 2 are missing. But when I check the dump file - those views are in the dump, but somehow they are not recreated. While the database is being restored - I've got error messages for relattioni "view_name" does not exist.
I even tried with pg_dumpall and still got the same result - any ideas to troubleshoot?
Thanks