Re: trouble with db-restore

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
Subject: Re: trouble with db-restore
Date: 2001-01-09 18:03:23
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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 Luis Quintano 2001-01-09 18:03:37 Inheritance and Defaults
Previous Message Tom Lane 2001-01-09 17:59:45 Re: Re: Loading optimization