Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

A sql script generated by emaj_gen_sql_group() fails on fkey check #41

Open
beaud76 opened this issue Jul 21, 2020 · 0 comments
Open

A sql script generated by emaj_gen_sql_group() fails on fkey check #41

beaud76 opened this issue Jul 21, 2020 · 0 comments
Labels

Comments

@beaud76
Copy link
Collaborator

beaud76 commented Jul 21, 2020

The sql script generated by the emaj_gen_sql_group() functions family may fail at execution time if some recorded transactions used foreign keys temporarily set as DEFERRED. This may be the case if the script replays an E-Maj logged rollback operation that handled "deferrable initialy immediate" fkeys. As a workaround, you may add SET CONSTRAINTS ... DEFERRED statements inside the generated transaction.

@beaud76 beaud76 added the bug label Jul 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant