Re: dump / restore functionality

> That seems like a rather spectacular overstatement of the likely
> benefits, not to mention a misdescription of what was discussed.
> 
> AFAIR what was discussed was separating

Yes, that is what was discussed.

>     - schema stuff needed before loading data
>     - table data
>     - schema stuff needed after loading data
> where the last category boils down to "indexes and then foreign keys".
> All the "other stuff" such as functions really needs to be in the
> first part ... or at least there's no visible benefit to delaying
> loading it.

Right. This breakdown I still think would be useful. An additional item 
that would be useful is to allow pg_restore to restore plain text dumps.

Sincerely,

Joshua D. Drake



> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 


-- 
   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240   Providing the most comprehensive  PostgreSQL
solutionssince 1997             http://www.commandprompt.com/