Ralf Schuchardt wrote:
> Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer <andreas@a-kretschmer.de>:
>> 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.
... or you can edit the dump and change the necessary DDL statements.
Yours,
Laurenz Albe