Postgres 7 pgdump problems

From: "Rainer Mager" <rmager(at)vgkk(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres 7 pgdump problems
Date: 2000-11-21 00:24:54
Message-ID: NEBBJBCAFMMNIHGDLFKGAELDCHAA.rmager@vgkk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi all,

We've run into an odd problem here. We had a db that we upgraded to PG7
without problems. We then dumped that db via pgdump and restored it to a
different server. The odd part is that the restored database had at least
one view from the original db that magically turned into a table (not a
view) in the new db. This broke some of our code that accesses the db (I
can't remember exactly why off hand) so I had to delete the table and
recreate it as a view by hand.
Has anyone else seen this? It smells like a bug to me.

--Rainer

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wuttipong Suvaphrom 2000-11-21 12:23:15 v7.0.3 on Solaris 2.7
Previous Message Lamar Owen 2000-11-20 19:57:41 Re: Logging

Browse pgsql-general by date

  From Date Subject
Next Message Partyka Robert 2000-11-21 00:29:02 alter database name ?
Previous Message Tom Lane 2000-11-21 00:11:40 Re: trying to move from MySQL