From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Naz Gassiep <naz(at)mira(dot)net>, Andreas Joseph Krogh <andreak(at)officenet(dot)no>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_dump schema breakup |
Date: | 2006-08-18 17:48:38 |
Message-ID: | 44E5FD76.2070905@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Joshua D. Drake wrote:
>
>>>> I think what you may really be after is "the stuff that should be
>>>> loaded
>>>> before inserting data" and "the stuff that should be loaded after",
>>>> but
>>>> the above are poor names for these concepts.
>>>>
>>>
>>> But it certainly would be nice to be able to dump all that "stuff":-)
>> Yea, I've been told that this would not be a high demand feature. So
>> do I have a second vote? ;-)
>
> The ability to have a dump that automatically separated the
> before-data and after-data objects is definitely
> useful. The amount of times I have had to dump the schema and data
> separately just so I can modify the
> schema before restore, or disable some function that is causing
> problems can not even be counted.
>
We already have a highly selective and configurable restore mechanism,
using the -L feature of pg_restore. Maybe there's a good special case
for this particular split, but it is hardly undoable now.
As for Naz' needs - I gave him a perl script I whipped up in few minutes
to do the split he wanted - and I'm sure you could do the same in python ;-)
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-08-18 18:04:20 | Re: Windows 2000 Support |
Previous Message | Joshua D. Drake | 2006-08-18 17:39:38 | Re: pg_dump schema breakup |