Re: trouble with db-restore

I have seen that before on my own system.  Same PG version for dump/restore.
Wasn't a big deal for me to redo the views since I had so few (i.e. 1)  I
never reported it, but it happened more than once.  Not sure of version, but
was 7.0.1 or 7.0.2.

--rob

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Heiko Irrgang" <irrgang@SC-Networks.de>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, January 09, 2001 1:03 PM
Subject: Re: trouble with db-restore


> Heiko Irrgang <irrgang@SC-Networks.de> writes:
> > i simply use pg_dumpall with no params for dumping the
> > data, but when i used psql for restoring the data,
> > every view was created as a table and was filled up
> > with the data which the view had been delivered at
> > the time of the backup.
>
> This is extremely surprising; I've never heard of such a report before.
>
> It would seem that pg_dump failed to recognize your views as being
> views.  The only theory I can come up with offhand is that you are
> using a pg_dump version that is not compatible with the database
> server version you are running.  Since you have said nothing about
> what version you are using, it's hard to guess more ...
>
> regards, tom lane
>