Thread

1. Is anyone working on pg_dump?

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-02-27T18:00:23Z

   One of the major must-fix items remaining on my to-do-for-7.0 list
   is making pg_dump smarter about the order to dump stuff in, so as
   to avoid problems like table constraints referring to not-yet-
   defined functions.
   
   We have talked about this before, and I thought some people had
   expressed interest in fixing it, but I haven't seen any results.
   Is anyone working on it?
   
   If not, I'm willing to do the quick-and-dirty approach of sorting
   the objects by OID.  This could be extended later to allow a
   dependency-based sort, but I don't have the time or interest to
   attempt that now.
   
   I'd be just as happy to yield the project to someone else though ;-)
   
   			regards, tom lane
   
   

2. Re: [HACKERS] Is anyone working on pg_dump?

   Peter Eisentraut <peter_e@gmx.net> — 2000-02-27T23:58:27Z

   Tom Lane writes:
   
   > We have talked about this before, and I thought some people had
   > expressed interest in fixing it, but I haven't seen any results.
   > Is anyone working on it?
   
   That was me, but not for 7.0. Feel free to try the oid thing, if it works
   well, I might not have to do my thing so early.
   
   
   -- 
   Peter Eisentraut                  Sernanders väg 10:115
   peter_e@gmx.net                   75262 Uppsala
   http://yi.org/peter-e/            Sweden
   
   
   

3. Re: [HACKERS] Is anyone working on pg_dump?

   Mark Hollomon <mhh@nortelnetworks.com> — 2000-02-28T12:50:35Z

   Tom Lane wrote:
   > 
   > One of the major must-fix items remaining on my to-do-for-7.0 list
   > is making pg_dump smarter about the order to dump stuff in, so as
   > to avoid problems like table constraints referring to not-yet-
   > defined functions.
   > 
   > We have talked about this before, and I thought some people had
   > expressed interest in fixing it, but I haven't seen any results.
   > Is anyone working on it?
   
   I had expressed interest in working on this, but have run out of
   spare time. Please feel free.
   
   -- 
   
   Mark Hollomon
   mhh@nortelnetworks.com
   ESN 451-9008 (302)454-9008
   
   

4. Re: Is anyone working on pg_dump?

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-02-29T15:28:37Z

   I wrote:
   > One of the major must-fix items remaining on my to-do-for-7.0 list
   > is making pg_dump smarter about the order to dump stuff in, so as
   > to avoid problems like table constraints referring to not-yet-
   > defined functions.
   
   I spent a couple evenings working on this, and have made good progress;
   but looking at how much I've changed and how much remains, I'm forced
   to realize that this is "too big a change for beta".  It requires a
   major restructuring of pg_dump.  Since we don't have regression tests
   for pg_dump, I think the risk of breaking something is too high for
   this phase of the release cycle.
   
   I plan to set the unfinished code aside for now, and come back to it
   early in the 7.1 cycle.  We'll have to live with the ordering issue
   for another release.
   
   			regards, tom lane