Socrates_docker / migrations /add_combative_pending_question.sql
AlessandroAmodioNGI's picture
fix: gate Stage C on genuine contradiction; track pending secondary point
9757c94
Raw
History Blame Contribute Delete
1.11 kB
-- ============================================================
-- Migration: add pending_question to 01_combative_dialogue.
--
-- Problem: when the user raises two separate unconnected points
-- during a combative exchange, Stage C incorrectly names a
-- "contradiction" between them. The second unresolved point is
-- then lost — there is nowhere to record it.
--
-- Solution: pending_question stores the secondary/original point
-- that is set aside when the dialogue shifts to a definitional
-- sub-topic. The verdict (Stage F) gestures toward it in the
-- closing line so the user is aware it remains open.
--
-- Run once in the Supabase SQL editor.
-- ============================================================
ALTER TABLE "01_combative_dialogue"
ADD COLUMN IF NOT EXISTS pending_question text;
-- ============================================================
-- Verify
-- ============================================================
-- SELECT column_name, data_type
-- FROM information_schema.columns
-- WHERE table_name = '01_combative_dialogue'
-- AND column_name = 'pending_question';