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" <[EMAIL PROTECTED]> To: "Heiko Irrgang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, January 09, 2001 1:03 PM Subject: Re: trouble with db-restore > Heiko Irrgang <[EMAIL PROTECTED]> 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 >
