Re: I incrementally altered my database into a state where backups couldn't be restored. - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: I incrementally altered my database into a state where backups couldn't be restored.
Date
Msg-id 47286659.4060406@enterprisedb.com
Whole thread Raw
In response to Re: I incrementally altered my database into a state where backups couldn't be restored.  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-bugs
Heikki Linnakangas wrote:
> 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.

Greg Stark pointed out that the above doesn't work either, though it's
not the exact same output you posted.

I don't see any feasible way to fix that, unfortunately. We'd need to
rewrite view definition quite a bit behind the scenes.

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

pgsql-bugs by date:

Previous
From: Gregory Stark
Date:
Subject: Re: I incrementally altered my database into a state where backups couldn't be restored.
Next
From: "Adam Tomjack"
Date:
Subject: Re: I incrementally altered my database into a state where backups couldn't be restored.