[PR #21351] [CLOSED] fix: PostgreSQL cannot use get_chat_ids_by_model_id #49088

Closed
opened 2026-04-30 01:24:16 -05:00 by GiteaMirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/open-webui/open-webui/pull/21351
Author: @EntropyYue
Created: 2/13/2026
Status: Closed

Base: devHead: fix/chat-messages


📝 Commits (1)

  • 646101d fix: PostgreSQL cannot use get_chat_ids_by_model_id

📊 Changes

1 file changed (+14 additions, -9 deletions)

View changed files

📝 backend/open_webui/models/chat_messages.py (+14 -9)

📄 Description

Changelog Entry

Description

  • PostgreSQL does not allow ordering by columns not included in the SELECT list when using SELECT DISTINCT, while SQLite handles this automatically.

Fixed

  • Fixed the issue where PostgreSQL could not use get_chat_ids_by_model_id

Contributor License Agreement

By submitting this pull request, I confirm that I have read and fully agree to the Contributor License Agreement (CLA), and I am providing my contributions under its terms.

Note

Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/open-webui/open-webui/pull/21351 **Author:** [@EntropyYue](https://github.com/EntropyYue) **Created:** 2/13/2026 **Status:** ❌ Closed **Base:** `dev` ← **Head:** `fix/chat-messages` --- ### 📝 Commits (1) - [`646101d`](https://github.com/open-webui/open-webui/commit/646101d0c91d5ef48bd679efeefdc1acc985ea72) fix: PostgreSQL cannot use get_chat_ids_by_model_id ### 📊 Changes **1 file changed** (+14 additions, -9 deletions) <details> <summary>View changed files</summary> 📝 `backend/open_webui/models/chat_messages.py` (+14 -9) </details> ### 📄 Description <!-- ⚠️ CRITICAL CHECKS FOR CONTRIBUTORS (READ, DON'T DELETE) ⚠️ 1. Target the `dev` branch. PRs targeting `main` will be automatically closed. 2. Do NOT delete the CLA section at the bottom. It is required for the bot to accept your PR. --> # Changelog Entry ### Description - PostgreSQL does not allow ordering by columns not included in the SELECT list when using SELECT DISTINCT, while SQLite handles this automatically. ### Fixed - Fixed the issue where PostgreSQL could not use get_chat_ids_by_model_id ### Contributor License Agreement <!-- 🚨 DO NOT DELETE THE TEXT BELOW 🚨 Keep the "Contributor License Agreement" confirmation text intact. Deleting it will trigger the CLA-Bot to INVALIDATE your PR. --> By submitting this pull request, I confirm that I have read and fully agree to the [Contributor License Agreement (CLA)](https://github.com/open-webui/open-webui/blob/main/CONTRIBUTOR_LICENSE_AGREEMENT), and I am providing my contributions under its terms. > [!NOTE] > Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2026-04-30 01:24:16 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/open-webui#49088