Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-20862

Re-enable triggers when the ACL optimizations are reactivated on PostgreSQL/SQL Server

    XMLWordPrintable

    Details

      Description

      When the ACL optimization is disabled, 3 triggers are also disabled with this code:

      #IF: ! aclOptimizationsEnabled
      ALTER TABLE acls DISABLE TRIGGER nx_trig_acls_modified;
      
      #IF: ! aclOptimizationsEnabled
      ALTER TABLE hierarchy DISABLE TRIGGER nx_trig_hierarchy_modified;
      
      #IF: ! aclOptimizationsEnabled
      ALTER TABLE aclr DISABLE TRIGGER nx_trig_aclr_modified;
      

      but when the optimization is enabled, nothing enables the triggers.

      Therefore all the newly created documents cannot be found for normal users, when the ACL optimization is on.

      Note that a similar problem is present on SQL Server.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.