superfly / fly-pr-review-apps

Github Action for PR Review Apps on Fly.io
Apache License 2.0
186 stars 116 forks source link

Reassign db objects before dropping user #39

Closed davidudo closed 11 months ago

davidudo commented 11 months ago

In the current review app deployment implementation, before launching a pull request app, any user with the PR app name in the PostgreSQL cluster is first dropped, but what if a user cannot be dropped because it owns some database objects (such as tables, views, functions, etc.)? In this case, these objects need to be reassigned to a reliable user like postgres before dropping the user.

Closes #19