Shanmugasundaram Doraisamy <shan@ceedees.com> writes: > Thanks for all your support to my previous > postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I > am facing is that when I take a dump of the DB using pg_dump and restore > it using the cat pg_dump_file |psql dbname, I find that some views and > functions are missing. What errors get reported during the psql run? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend