Tried this morning to recreate the problem, but could not (as of v 7.0.2). Perhaps it was 7.0.1? Sorry for not reporting earlier. I'll keep my eye out for this issue in the future. --rob ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "rob" <[EMAIL PROTECTED]> Cc: "Heiko Irrgang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 09, 2001 11:43 PM Subject: Re: trouble with db-restore > "rob" <[EMAIL PROTECTED]> writes: > > 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. > > You should have reported it :-( ... as I said, I hadn't heard about this > failure mode before. I assume that the dump script shows the views as > CREATE TABLE not CREATE VIEW? I'd ask you to send me the dump script, > but it's unlikely to tell me much if the error is upstream. Can you > provide a script for creating a view that pg_dump fails to dump > correctly? > > regards, tom lane >
