Foreign key constraint errors about ora2pg HOT 3 CLOSED

Update:

I used
FILE_PER_TABLE 1
FKEY_DEFERRABLE 0
DEFER_FKEY 0
DROP_FKEY 1

which resulted in separate files for each table. According to the documentation in ora2pg.conf this a possible configuration if one transaction (and one file) is too big to manage). But it doesn't work because in the latter commits the DROP CONSTAINT and CREATE CONSTRAINT are moved to the per table files as described above.

FILE_PER_TABLE 0 doesn't help because the DROP CONSTAINT and CREATE CONSTRAINT are still inserted around the individual table COPY.

As the size of my tables is managable it's a possible for me to change to:

FILE_PER_TABLE 0
FKEY_DEFERRABLE 1
DEFER_FKEY 1
DROP_FKEY 0

But the DROP_FKEY option is in reality broken.

from ora2pg.

Yes, Christian, sorry for the response delay. I understand what you mean and I'm agree that this is a regression. I will rewrite this part tonight or tomorrow.

from ora2pg.

This should have been fixed by last commit f552760.

from ora2pg.