Mercurial > hg > orthanc-databases

view PostgreSQL/Plugins/SQL/Upgrades/Rev6ToRev699.sql @ 740:2382e6fab2b6 pg-next-699

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added a new pk column in 2 tables to enable pg_repack
author Alain Mazy <am@orthanc.team>
date Mon, 22 Sep 2025 11:02:20 +0200
parents
children 2bf57bc22a30
line wrap: on
line source

-- Adding a PK to these 2 table to allow pg_repack to process these tables, enabling reclaiming disk space and defragmenting the tables.

ALTER TABLE InvalidChildCounts ADD COLUMN pk BIGSERIAL PRIMARY KEY;
ALTER TABLE GlobalIntegersChanges ADD COLUMN pk BIGSERIAL PRIMARY KEY;