Re: Unhappy thoughts about pg_dump and objects inherited from template1

Peter Eisentraut <peter_e@gmx.net> writes:
> When we implement schemas, then all objects belonging to the
> DEFINITION_SCHEMA will not be dumped, all other objects will be.  At least
> I imagine that this might be something to work with.

That's a thought, although it still doesn't cope with the issue of
"what if I've altered a standard system object?" ... which is what
I think Mark was getting at yesterday.  I'm not sure there's any
reasonable way to handle that, though, short of diff'ing against a
dump of template1 :-(

To bring this back from future nice solutions to the reality of what
to do today, do people like the "template0" solution for now (7.1)?
I can work on it if so.
        regards, tom lane