Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>: > hello all, > > don't ask why, but a customer created tables with foreign key constraints but > with inconsistent data. > > Because of this he disabled all triggers (alter table foo disable trigger all). > So far, so bad ... > (he can't clean the data at the moment) > > In the dump there are the constraints, but NOT the disable triggers. In other > words: no way to restore. > > What can we do now? pg_restore has a --disable-triggers option, that could be of some help. Or you add the command to the top of the sql dump file. Ralf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general