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" <tgl@sss.pgh.pa.us>
To: "rob" <rob@cabrion.com>
Cc: "Heiko Irrgang" <irrgang@SC-Networks.de>; <pgsql-general@postgresql.org>
Sent: Tuesday, January 09, 2001 11:43 PM
Subject: Re: trouble with db-restore
> "rob" <rob@cabrion.com> 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
>