|To:||"Heiko Irrgang" <irrgang(at)SC-Networks(dot)de>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>|
|Subject:||Re: trouble with db-restore|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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>
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
|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|