Hi,
It would be great if this issue could be implemented, I have a use case
for testing. How do I get access to JIRA to update the ticket? (to
include the sql files for testing).
When importing data into the database (which has foreign keys and unique
constraints) this is useful. Import fails due to a deferred constraint
violation due to the unique index
(SQL0000000140-0fe82566-018d-4f9a-090e-0000170eba31):
ERROR 23516: The transaction was aborted because of a deferred
constraint violation: Foreign key
'FOREIGN_KEY_director_talent_id_talent_talent_id' defined on
"APP"."DIRECTOR" referencing constraint
'SQL0000000140-0fe82566-018d-4f9a-090e-0000170eba31' defined on
"APP"."TALENT", key ''.
Import flow is (in ij):
autocommit off;
run('movies_insert.sql');
commit;
Foreign keys are created with deferred constraints (deferrable initially
deferred).
Any help for a workaround or fix is highly appreciated.
Best regards,
Bart
