Noémi Ványi
Noémi Ványi
When loading inputs from external files is enabled and there is only one `filestream` input enabled the following error is returned after the first reload: ``` filestream input with ID...
### Goal My goal is to unify all database actions pgroll is executing. Example actions include dropping columns, renaming columns, creating and dropping triggers, creating constraints, etc. We can define...
This PR adds support for running SQL migration files using `pgroll`. SQL migrations files must have `up.sql` suffix. You can define your up migration in `{migration_name}.up.sql` files. Down migrations are...
If there is a pending migration when running `pgroll migrate`, do not return an error. This can be useful when running `migrate` in a CI/CD env, and many jobs are...
When you are experimenting with migrations in your local database, you might end up with a broken migration state. You might write a bad SQL expression that pgroll fails to...
We would like to add a new flag to `start`, `complete` and `rollback` named `verbose`. When this flag is set, `pgroll` prints what operations it is running to show users...
Add support for `nulls_not_distinct` option in `create_constraint` and `create_index` operations for unique constraints and indexes. `NULLS NOT DISTINCT` was introduced in PG 15, so I added some conditionals to check...
Other migration tools run raw SQL migrations in a single transaction. So if a migration fails, the database rolls back all changes the transaction has made. At the moment `pgroll`...
`pgroll` gives access to multiple schema versions by hiding tables behind views. At the moment, `pgroll` does not have a way to provide access to multiple versions of the same...
PostgreSQL 14 EOL is at 12 Nov 2026. Afterwards we can remove support for this PG version. This issue collects the compatibility logic we had to add to make sure...