Files
windmill/backend/migrations/20260423132025_flow_conversation_message_created_seq.down.sql
centdix 7fa924e67e fix: correct flow conversation pagination (#8919)
* fix: remove conversation after_id filter

* fix: implement message after_id cursor

* fix: use persisted cursor for chat polling

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

* refactor: simplify message cursor ordering

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

* refactor: use cte for message cursor

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

* Update SQLx metadata

* fix: use monotonic flow message cursor

* Update SQLx metadata

* fix: tighten flow message cursor pagination

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

* Update SQLx metadata

---------

Co-authored-by: Claude Opus 4.5 <noreply@anthropic.com>
Co-authored-by: windmill-internal-app[bot] <windmill-internal-app[bot]@users.noreply.github.com>
2026-04-23 16:29:29 +00:00

11 lines
401 B
SQL

DROP INDEX IF EXISTS idx_conversation_message_conversation_created_seq;
CREATE INDEX IF NOT EXISTS idx_conversation_message_conversation_time
ON flow_conversation_message(conversation_id, created_at DESC);
ALTER TABLE flow_conversation_message
DROP CONSTRAINT IF EXISTS flow_conversation_message_created_seq_key;
ALTER TABLE flow_conversation_message
DROP COLUMN IF EXISTS created_seq;