Skip to end of banner
Go to start of banner

Ramsons (R2 2024) Required manual migrations

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Module

Instructions

Comments

Contact person,
automation Jira

mod-entities-links

Manually executed script for each tenant

SET search_path TO <tenantId>_mod_entities_links;
-- Find deleted records in authority table; index avoids two full table scans
CREATE INDEX IF NOT EXISTS authority_deleted_idx ON authority(deleted) WHERE deleted;
-- Move to archive
INSERT INTO authority_archive SELECT * FROM authority WHERE deleted = true ON CONFLICT DO NOTHING;
-- Delete deleted
DELETE FROM authority WHERE deleted = true;
-- Drop index
DROP INDEX authority_deleted_idx;

Due to migration issues in previous releases, there may be cases where deleted authority records are not transferred to the authority archive. While this doesn't significantly impact functionality, moving them to the correct location would enhance consistency.

MODELINKS-270 - Getting issue details... STATUS

  • No labels