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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
