Opened 7 years ago
Last modified 5 years ago
#29377 closed New feature
DatabaseSchemaEditor: add a hook to run DML statements after the entire schema is created — at Initial Version
Reported by: | Maximiliano Robaina | Owned by: | nobody |
---|---|---|---|
Component: | Migrations | Version: | 2.0 |
Severity: | Normal | Keywords: | |
Cc: | Maximiliano Robaina, Simon Charette | Triage Stage: | Accepted |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
This feature request is to better support of third-party database backends.
In my case (Firebird SQL) to add a new field on already existing and populated table is not enough set and drop a default value, we need to update the new field with efective default value. It is not possible without commit the schema alteration.
An aproach could be to have a kind of hook to run sql statements (DML statement in this case) when the schema altereation finished (and commited). Of course, must bu runned in another transaction.