Re: trouble with db-restore

From: "rob" <rob(at)cabrion(dot)com>
To: "Heiko Irrgang" <irrgang(at)SC-Networks(dot)de>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: trouble with db-restore
Date: 2001-01-10 02:00:10
Message-ID: 002401c07aa9$10e46880$
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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.


----- 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

In response to


Browse pgsql-general by date

  From Date Subject
Next Message Sandeep Joshi 2001-01-10 02:10:13 delete trigger function in 'C'
Previous Message Tatsuo Ishii 2001-01-10 01:58:59 Re: Re: [HACKERS] How to print explain using PHP