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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heiko Irrgang" <irrgang(at)SC-Networks(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, January 09, 2001 1:03 PM
Subject: Re: trouble with db-restore

> Heiko Irrgang <irrgang(at)SC-Networks(dot)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
>