Re: I incrementally altered my database into a state where backups couldn't be restored.

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Adam Tomjack <adamtj(at)zuerchertech(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: I incrementally altered my database into a state where backups couldn't be restored.
Date: 2007-10-31 10:06:06
Message-ID: 4728538E.7030106@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Adam Tomjack wrote:
> I was able to put my database into a state where I couldn't restore a
> backup without manually editing the backup file.

I can't reproduce that on 8.1 or 8.2 or CVS HEAD. pg_dump produces this
CREATE statement for the view:

CREATE VIEW v_a_b_c AS
SELECT b.aid, b.bid, c.cid FROM ((b JOIN c USING (bid)) JOIN a
USING (aid));

Not the CREATE OR REPLACE with a SELECT * you posted.

Which version of Postgres are you using?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gregory Stark 2007-10-31 10:56:09 Re: I incrementally altered my database into a state where backups couldn't be restored.
Previous Message Adam Tomjack 2007-10-31 02:36:36 I incrementally altered my database into a state where backups couldn't be restored.