ERROR: permission denied to set parameter "session_replication_role"

[7Sageer]

Describe your question

In my upload part, I use SET session_replication_role = 'replica' to temporarily remove foreign key. When I execute the online benchmark, I found that there's a error that "ERROR: permission denied to set parameter "session_replication_role"". Is it not permitted in benchmark? Should I remove this? If I doing so, what should I do to replace it?

[hezean]

your program will run under a regular user who is nothing else than the owner of the test db, thus you won't have the permission to alter such system config. you need to find the solution by yourself since this is your project and we won't provide you such detailed guidance.