Re: Unhappy thoughts about pg_dump and objects inherited from template1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Unhappy thoughts about pg_dump and objects inherited from template1
Date
Msg-id 11664.973874369@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Mark Hollomon <mhh@mindspring.com>)
Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Philip Warner <pjw@rhyme.com.au>)
Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Jan Wieck <janwieck@Yahoo.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Could turn on -O2 in AIX
Next
From: Tom Lane
Date:
Subject: Re: AW: Could turn on -O2 in AIX