Add support for generated columns in Postgres 12+. Fixes #4334 Ensure columns can be created when they are IDENTITY fields with the CYCLE option enabled. Fixes #4496 Ensure purely numeric comments can be saved on new columns. Fixed #4497
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=2ef3080d0eb2c54e90c32e1cad814062afec9be5 Author: Akshay Joshi <akshay.jo...@enterprisedb.com> Modified Files -------------- docs/en_US/column_dialog.rst | 60 +++++ docs/en_US/images/column_constraint_generated.png | Bin 0 -> 54461 bytes docs/en_US/images/column_constraint_identity.png | Bin 0 -> 74201 bytes docs/en_US/images/column_constraints.png | Bin 0 -> 47511 bytes docs/en_US/images/column_definition.png | Bin 28807 -> 44189 bytes docs/en_US/images/column_general.png | Bin 21471 -> 38051 bytes docs/en_US/images/column_security.png | Bin 26092 -> 43456 bytes docs/en_US/images/column_variables.png | Bin 23043 -> 41178 bytes docs/en_US/release_notes_4_12.rst | 3 + .../databases/schemas/tables/columns/__init__.py | 8 +- .../schemas/tables/columns/static/js/column.js | 241 ++++++++++++++------ .../tables/columns/tests/test_column_add.py | 124 +++++++---- .../tables/columns/tests/test_column_put.py | 109 +++++---- .../schemas/tables/columns/tests/utils.py | 49 +++++ .../templates/columns/sql/10_plus/create.sql | 8 +- .../templates/columns/sql/10_plus/properties.sql | 1 + .../templates/columns/sql/10_plus/update.sql | 13 +- .../templates/columns/sql/12_plus/create.sql | 46 ++++ .../templates/columns/sql/12_plus/properties.sql | 48 ++++ .../templates/columns/sql/default/create.sql | 2 +- .../tables/templates/tables/sql/10_plus/create.sql | 6 +- .../tables/templates/tables/sql/12_plus/create.sql | 7 +- .../tables/templates/tables/sql/default/create.sql | 2 +- .../templates/tables/sql/gpdb_5.0_plus/create.sql | 2 +- .../schemas/tables/tests/test_table_add.py | 245 ++++++++++----------- .../databases/schemas/tables/tests/utils.py | 78 +++++++ web/pgadmin/static/js/backform.pgadmin.js | 38 +++- web/pgadmin/static/scss/_bootstrap.overrides.scss | 8 + 28 files changed, 793 insertions(+), 305 deletions(-)
