Re: trouble with db-restore

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

> "rob" <rob(at)cabrion(dot)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
>