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.

Sign up for GitHub

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

Jump to bottom

Allow to run command(s) per connection at beginning and end #4

Open
isapir opened this issue Jul 11, 2018 · 1 comment
Open

Allow to run command(s) per connection at beginning and end #4

isapir opened this issue Jul 11, 2018 · 1 comment
Assignees
@isapir
Labels
enhancement New feature or request

Comments

@isapir
Copy link
Owner

isapir commented Jul 11, 2018

e.g. to disable the TRIGGERS before DML operations run:

SET session_replication_role = replica;

and then re-enable them at the end with:

SET session_replication_role = DEFAULT;
@isapir isapir self-assigned this Jul 11, 2018
@isapir isapir added the enhancement New feature or request label Jul 11, 2018
@isapir
Copy link
Owner Author

isapir commented Jul 18, 2018

In the meantime added queries dml.execute.before_all and dml.execute.after_all in 86c30b3 which allows to disable triggers before copying and re-enable them afterwards

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@isapir isapir

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@isapir