dump doesn't save views and blobs - Mailing list pgsql-hackers

From lorenzo@argon.roma2.infn.it
Subject dump doesn't save views and blobs
Date
Msg-id 199901261849.TAA31488@argon.roma2.infn.it
Whole thread Raw
List pgsql-hackers
So good,I'm just starting a couple of db projects, and would like to run
them on PG, whose feature set seems rich enough for my needs... Now, I see
almost any new release added very useful stuff (as opposed to some well
known office suite new releases, adding mostly uncollected garbage), but
there is the dump/reload needed to realign tables to the changed server;
very good: no need to waste server's time in on the fly conversion from
legacy format to the current data representation... Still, I see those big
warnings about un-dumpable BLOBs and views; I understand the second is
impossible since views are stored only after having been "massaged" into
rules; still, I think that in the long term both should be 'teleported'
from one releases' to the next one's format, but I feel that BLOBs should
be handled asap... IMHO, this should be considered at the very least as a
big inconvenience, but I can hear people laughing at this big "feature" as
a DOCUMENTED bug of an seemengly excellent free program. Sorry for not
being able to submit code to correct this state of facts, I hope you will
not take this note as an offense, or the troll it isn't, but as a real
concern for a real problem I'm going to face. At the very least, I'm
surprised not to see the incomplete dump problem noted in PG's TODO list.
Yours,


l.




pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: alloca (was: Postgres Speed or lack thereof)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: alloca (was: Postgres Speed or lack thereof)