Dixi quod… > ‣‣‣ What have I expected? > > That pg_dump recognises the dependency (there i̲s̲ a FOREIGN KEY reference > in there) and reorders the tables dumped.
I’d actually be happy if there were a way to restore those dumps, for example by temporarily disabling constraint checks during the restore. This MUST NOT cost consistence though — constraint checks would, in this restore mode, need to be re-enabled AND all data checked against them BEFORE the --single-transaction surrounding all this finishes, and abort it if any data fails the constraints. Well, actually even happier as it would allow me to restore such dumps created by those buggy pg_dump versions, which are abundant. Thanks in advance, //mirabilos -- tarent solutions GmbH Rochusstraße 2-4, D-53123 Bonn • http://www.tarent.de/ Tel: +49 228 54881-393 • Fax: +49 228 54881-235 HRB 5168 (AG Bonn) • USt-ID (VAT): DE122264941 Geschäftsführer: Dr. Stefan Barth, Kai Ebenrett, Boris Esser, Alexander Steeg
