Skip to main content

Migrations in Aurora PostgreSQL

Depot migrations are supported in Aurora PostgreSQL. However, there are some limitations to be aware of.

Postgres views limitations​

PostgreSQL views doesn't support recreation by CREATE OR REPLACE VIEW statement. Therefore, there are some rules that need to be followed in order for view updates to work:

  • columns can be added at the end of the view SQL statement
  • columns cannot be removed from the view at all.
  • columns cannot be renamed at the moment, track Depot releases for updates on this.
  • Tables that are referenced by view can be altered, but only if the change is not structural (e.g. column type change is not allowed, but column name change is allowed).

This may be addressed in future Depot releases (DPT-2607).