Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer <andreas@a-kretschmer.de>:
> 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
dumpfile.
Ralf