From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | pgAdmin 4 commit: Added support of Declarative Partitioning (Range, Lis |
Date: | 2017-07-07 06:30:01 |
Message-ID: | E1dTMm9-0007DJ-Le@gothos.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Added support of Declarative Partitioning (Range, List) for PostgreSQL 10.
This allows the user to create partitioned table and it's partitions.
- Edit partitions, Create/Listing of constraints, rules, triggers under partitions. (Implemented by Harshal)
- Updating browser tree node when create/attach/detach partitions from table dialog.(Implemented by Ashesh)
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=c2fb0394bf4238fde94372bba88fa07330fdafbb
Modified Files
--------------
.../servers/databases/schemas/static/js/schema.js | 36 +
.../servers/databases/schemas/tables/__init__.py | 2170 +++----------------
.../tables/column/templates/column/js/column.js | 26 +-
.../schemas/tables/column/tests/test_column_get.py | 2 +-
.../check_constraint/js/check_constraint.js | 15 +-
.../js/exclusion_constraint.js | 19 +-
.../templates/foreign_key/js/foreign_key.js | 19 +-
.../index_constraint/js/index_constraint.js | 27 +-
.../templates/constraints/js/constraints.js | 4 +-
.../databases/schemas/tables/indexes/__init__.py | 156 +-
.../tables/indexes/templates/index/js/index.js | 31 +-
.../schemas/tables/partitions/__init__.py | 583 ++++++
.../partitions/static/img/coll-partition.png | Bin 0 -> 1433 bytes
.../tables/partitions/static/img/partition.png | Bin 0 -> 1264 bytes
.../tables/partitions/static/js/partition.js | 1276 ++++++++++++
.../tables/rules/templates/rules/js/rules.js | 12 +-
.../schemas/tables/static/js/partition.utils.js | 323 +++
.../databases/schemas/tables/static/js/table.js | 520 ++++-
.../templates/partition/sql/10_plus/attach.sql | 2 +
.../partition/sql/10_plus/backend_support.sql | 9 +
.../templates/partition/sql/10_plus/create.sql | 30 +
.../templates/partition/sql/10_plus/detach.sql | 1 +
.../partition/sql/10_plus/get_attach_tables.sql | 23 +
.../templates/partition/sql/10_plus/nodes.sql | 15 +
.../templates/partition/sql/10_plus/properties.sql | 82 +
.../tables/templates/table/sql/10_plus/acl.sql | 46 +
.../templates/table/sql/10_plus/get_inherits.sql | 17 +
.../tables/templates/table/sql/10_plus/get_oid.sql | 5 +
.../templates/table/sql/10_plus/get_table.sql | 8 +
.../tables/templates/table/sql/10_plus/nodes.sql | 9 +
.../templates/table/sql/10_plus/properties.sql | 73 +
.../tables/templates/table/sql/default/create.sql | 3 +-
.../templates/table/sql/default/get_schema_oid.sql | 3 +-
.../schemas/tables/tests/test_table_add.py | 61 +-
.../schemas/tables/tests/test_table_delete.py | 2 +-
.../schemas/tables/tests/test_table_put.py | 89 +-
.../databases/schemas/tables/tests/utils.py | 150 ++
.../triggers/templates/trigger/js/trigger.js | 37 +-
.../servers/databases/schemas/tables/utils.py | 2178 ++++++++++++++++++++
.../browser/templates/browser/js/browser.js | 197 +-
web/pgadmin/browser/templates/browser/js/node.js | 22 +-
.../tools/backup/templates/backup/js/backup.js | 2 +-
web/pgadmin/tools/datagrid/__init__.py | 26 +-
.../datagrid/templates/datagrid/js/datagrid.js | 2 +-
.../templates/maintenance/js/maintenance.js | 13 +-
.../tools/restore/templates/restore/js/restore.js | 3 +-
web/pgadmin/utils/__init__.py | 3 +
web/pgadmin/utils/exception.py | 8 +
48 files changed, 6275 insertions(+), 2063 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Akshay Joshi | 2017-07-07 06:35:26 | Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4 |
Previous Message | Fahar Abbas | 2017-07-07 05:08:46 | Re: Windows testing required: Updated runtime |