Обсуждение: Problem with pg_dump - reg.

Dear Group,
                     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.  But the same views when created manually in the
newly restored database works fine.  I would appreciate your input in
this regard.  I am using Redhat 7.3 on one machine and Redhat 8.0 on
another.  The same behavior is found on both.
Thanks in advance,

Shan.

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