www/wiki/maintenance/postgres/archives/patch-drop-ar_text.sql


1
2
3
4
5
6
7
8

-- T33223: Remove obsolete ar_text and ar_flags columns
-- (and make ar_text_id not nullable and default 0)

ALTER TABLE archive
  DROP COLUMN ar_text,
  DROP COLUMN ar_flags,
  ALTER COLUMN ar_text_id SET DEFAULT 0,
  ALTER COLUMN ar_text_id SET NOT NULL;