mirror of
https://github.com/kevinveenbirkenbach/computer-playbook.git
synced 2026-11-06 10:59:59 +00:00
kevinveenbirkenbachandClaude Opus 5.5
fe486a21e5
With the psql command tags gone the OIDC plugin task stays `ok`, but PeerTube was still force-recreated on every deploy: "Back-fill column defaults so bootstrap INSERT keeps NOT NULL" runs an unconditional `ALTER TABLE … SET DEFAULT`, database_query reports every non-SELECT as changed, and the task notifies compose-up, which runs `compose up -d --force-recreate`. A SELECT on information_schema.columns now lists the bootstrap columns (`nodeVersion`, `nodeABIVersion`) that still have no default, and the ALTER with its compose-up notification runs only when that list is not empty. A fresh database still gets the defaults before PeerTube's bootstrap INSERT retries; every later deploy skips the task. The unused register of the ALTER task is gone, and both read-only checks now live under files/sql/check-application/ as the sibling-prefix rule requires. Refs #1164 Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
7 lines
199 B
SQL
7 lines
199 B
SQL
SELECT column_name
|
|
FROM information_schema.columns
|
|
WHERE table_schema = 'public'
|
|
AND table_name = 'application'
|
|
AND column_name IN ('nodeVersion', 'nodeABIVersion')
|
|
AND column_default IS NULL;
|