1.3.3
Released: January 22, 2020
bug
-
[bug] [postgresql] Fixed issue where COMMENT directives for PostgreSQL failed to correctly
include an explicit schema name, as well as correct quoting rules for
schema, table, and column names. Pull request courtesy Matthew Sills.References: #637
usecase
-
[usecase] [operations] Added support for rendering of "computed" elements on
Column
objects, supported in SQLAlchemy via the newComputed
element
introduced in version 1.3.11. Pull request courtesy Federico Caselli.Note that there is currently no support for ALTER COLUMN to add, remove, or
modify the "GENERATED ALWAYS AS" element from a column; at least for
PostgreSQL, it does not seem to be supported by the database. Additionally,
SQLAlchemy does not currently reliably reflect the "GENERATED ALWAYS AS"
phrase from an existing column, so there is also no autogenerate support
for addition or removal of theComputed
element to or from an
existing column, there is only support for adding new columns that include
theComputed
element. In the case that theComputed
element is removed from theColumn
object in the table metadata,
PostgreSQL and Oracle currently reflect the "GENERATED ALWAYS AS"
expression as the "server default" which will produce an op that tries to
drop the element as a default.References: #624