beginners postgres question

Andreas Plesner Jacobsen apj at mutt.dk
Mon Oct 8 11:45:05 BST 2007


On Mon, Oct 08, 2007 at 11:25:08AM +0100, graham wrote:
> 
> At this point I discover that pg_dump produces dump files which cannot 
> be reloaded, since they take no account of dependencies. For example, I 
> have a lot of join tables, which necessarily depend on foreign keys from 
> other tables. But pg_dump produces output with these tables BEFORE the 
> ones the keys come from.

pg_dump dumps the constraints at the end, so this shouldn't be a
problem.

-- 
Andreas


More information about the london.pm mailing list