1) Added RLS Policy support in Schema Diff. Fixes #5601 2) Fixed 'cant execute empty query' issue when remove the value of 'USING' or 'WITH CHECK' option of RLS Policy. Fixes #5631
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=979f8061619db2fae306f93f998e280b60fd53aa Author: Pradip Parkale <pradip.park...@enterprisedb.com> Modified Files -------------- docs/en_US/release_notes_4_24.rst | 4 +- .../databases/schemas/functions/__init__.py | 17 -- .../servers/databases/schemas/tables/__init__.py | 3 + .../tables/row_security_policies/__init__.py | 190 ++++++++++++++++++--- .../static/js/row_security_policy.js | 17 +- .../tests/default/alter_policy.sql | 2 +- .../tests/default/create_all_event_policy.sql | 11 ++ .../tests/default/create_insert_policy.sql | 2 +- .../tests/default/create_public_policy.sql | 2 +- .../tests/default/create_select_policy.sql | 2 +- .../row_security_policies/tests/default/test.json | 24 ++- .../schemas/tables/row_security_policies/utils.py | 20 +-- .../databases/schemas/tables/schema_diff_utils.py | 2 +- .../databases/schemas/tables/static/js/table.js | 16 +- .../row_security_policies/sql/9.5_plus/create.sql | 5 - .../sql/9.5_plus/properties.sql | 10 +- .../row_security_policies/sql/9.5_plus/update.sql | 2 +- .../servers/databases/schemas/tables/utils.py | 2 +- 18 files changed, 245 insertions(+), 86 deletions(-)
