Misleading schema on pipeline

[ManuelMoeri]

When creating a migration that specifically migrates the okr_pitc schema locally the migration will fail but on the pipeline it runs just fine. This is due to the schema being used on the pipeline.

To Reproduce
Steps to reproduce the behavior:

1. Create a new migration
2. Use UPDATE okr_pitc.key_result and set a random value
3. Push the changes. The pipeline should run.
4. Start the backend locally and see the permission error

Expected behavior
The behaviour should be the same. So a failing pipeline would be the optimal solution. For this you'll need to change the schema that is used for the pipeline. Maybe even create custom one just for the pipeline.

System (please complete the following information):

• OS: Pop!_OS
• Browser: Firefox
• Version: 142.0.1