Postgres 7 pgdump problems - Mailing list pgsql-admin

From Rainer Mager
Subject Postgres 7 pgdump problems
Date
Msg-id NEBBJBCAFMMNIHGDLFKGAELDCHAA.rmager@vgkk.com
Whole thread Raw
In response to Re: Logging  (Lamar Owen <lamar.owen@wgcr.org>)
Responses Re: Postgres 7 pgdump problems  (Paul Breen <pbreen@computerpark.co.uk>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Logging
Next
From: Mário Jorge Nunes Filipe
Date:
Subject: [Re: Migrating from 6.3.2 to 6.5